Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to integrate Dynamics 365 F&O data to Fabric. I replicated the entities in Dynamics 365 F&O to Dataverse. They come as virtual tables in Datavese.
I am trying to use 'Link to Fabric' in Dataverse platform and shortcut in Fabric as well. But those do not replicate the virtual tables that had been brought to Dataverse.
Does anyone know how to solve this problem?
Solved! Go to Solution.
Hi, I was able to figure out the integration steps.
1. Need to enable SQL row version tracking
2. Build indexes for the tables in AX DB
3. Build the solution again in Visual Studio which takes a good amount of time (> 3 hours)
4. And then perform Link to Fabric and then select the tables which you require to be replicated.
The tables from D365 will be linked to a Fabric Lakehouse as a shortcut. There is one-to-one linkage. One D365 environment can be linked to only one Lakehouse.
Hi, I was able to figure out the integration steps.
1. Need to enable SQL row version tracking
2. Build indexes for the tables in AX DB
3. Build the solution again in Visual Studio which takes a good amount of time (> 3 hours)
4. And then perform Link to Fabric and then select the tables which you require to be replicated.
The tables from D365 will be linked to a Fabric Lakehouse as a shortcut. There is one-to-one linkage. One D365 environment can be linked to only one Lakehouse.
Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
Thanks.
Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks
Apologize for the inconvenience that you are facing here and delay in response from my end.
Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Thank you.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.