Posts

Showing posts from October, 2024

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...

Step by Step: bring D365F&O data to Microsoft Fabric Lakehouse

Image
  Hi friends: my today's topic is a much awaited topic on Integration between D365F&O with Azure Fabric Lakehouse. It's becoming a predominant topic of discussion whereby Microsoft is planning and targetting to bring everyting under one roof of Microsoft Fabric, which not only houses humoungous tools for Data extraction, ingestion, transformation, but also on Reporting and Data presentation.    Before we begin, let me give a sshort recap, on what is Microsoft Fabric? And how is Lakehouse even related here: 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: d...

Step by step: prepare Azure Synapse link for D365F&O, along with fixing some known issues

Image
Setting up Azure Synapse Link for D365F&O could be quite tricky, and has a lot of hurdles/precursors which you need to address in order to enbale Azure Synapse Link for D365F&O. There are a number of pre-onboarding activities you need to execute, a number of setups you need to keep handy, a number of aacounts you need to setup beforehand, before you go for setting up an Azure Synapse Link For F&O. The following article tells the steps to Azure Synapse Link enablement for D365F&O, along with the various kinds of issues which might face whilee doing so, along with their resolutions. 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:   Create a new Azure Synapse Analytics Workspace, by filling out the following form from Azure portal: Click on Review + Create ...