Bring data to Microsoft Fabric Onelake from D365F&O (no Azure SQL needed)
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...