Posts

Showing posts with the label Dataverse

Bring data to Microsoft Fabric Onelake from D365F&O (no Azure SQL needed)

Image
  Hi freinds, in one of recent blogs, I chalked out an integration stratgey pattern of setting up of D365F&O with Microsoft Fabric, by routing it through a DMF batch job to Azure SQL. This currrent blog talks about even a cool hack of direct integration between D365F&O and Microsoft Fabric, just harnessing Synapse Link itself -- no additional/intermeidary steps are required. Here are the steps: Step 1:  Create a Datalake Storage account in Azure Portal, with the following settings:  Don't forget to mark the following setting, from the advanced tab: Click Review + create >> Create to complete the wizard to create the Storage account. Step 2:  Come to PowerApps page (https://make.powerapps.com/environments), and check if you are able to view the  Azure Synapse Link: If not, then you have to click on More >> Discover all >> You should be able to see it as under the Data management: Ensure that you are on the correct environment: Step 3: On...

Bring data from Dataverse to Microsoft Fabric Lakehouse, using Pipeline

Image
Amigos, this blog could give you an insight as to how to fetch data from Microsoft Dataverse. To begin with, we all know what is Micrsoft Fabric: Microsoft Fabric is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It encompasses data movement, processing, ingestion, transformation, real-time event routing, and report building. Microsoft Fabric is a data analytics platform that helps organizations manage, access, and act on data. It's designed to address all aspects of an organization's analytics needs, including all ingredients of data movement like: data processing, ingestion, and transformation, as well as real-time analytics to allow users to explore, analyze, and act on large volumes of streaming data in near-real time.  Not to mention enough rooms for a number of services from Data Science like Data Lake and ingestion. Just before we jump to our next topic, let me introduce you to Lakehouse (just in case, you've not ...