Forum Discussion
Importing data from a Dynamics 365 CRM solution into Fabric
Hi,
I need to evaluate the possible methods to import data from a Dynamics 365 CRM solution into Fabric.
I hope that it exists a direct connection to use in order to accomplish a such task and it exists a method as better as possible in terms of performance and costs.
Any suggests to me, please? Thanks
Hi pmscorca,
please also look into our similar community solved threads, let me know if this helps?
Solved: Getting data from Dynamics 365 Business Central to... - Microsoft Fabric Community
Thanks,
Prashanth Are
MS Fabric community
7 Replies
- ToddChitt
Super User
We set this up for a client several months back but for the life of my I couldn't recall the exact steps. I do know, however, that we STARTED in Dynamics CRM with a Sync Agent and during configuration specified the Fabric Workspace to target the synchronized data. What we got was a lakehouse named something like this:
It synchronizes ALL data from ALL tables with no additional programming overhead. (But it did take a few days to get the initial data load completed.)
Side note: If you are using Dynamics Business Central, that is a whole different animal and does NOT support this type of sync agent. You need to use Dataflow to go PULL the data you specifically want.
Hope that helps.
- pmscorca
Post Prodigy
Hi, thanks for your reply but I hope in a general answer with major details about features and connections to use, in order to evaluate a method as better as possible in terms of performance and costs.
- ToddChitt
Super User
You need to do some research on your own, not simply post your request here and expect someone to give you a solution.
Start here: Link your Dataverse environment to Microsoft Fabric and unlock deep insights - Power Apps | Microsoft Learn
- v-prasare
Community Support
Hi pmscorca,
please also look into our similar community solved threads, let me know if this helps?
Solved: Getting data from Dynamics 365 Business Central to... - Microsoft Fabric Community
Thanks,
Prashanth Are
MS Fabric community
- v-prasare
Community Support
Hi @ToddChitt,
We would like to follow up to see if your query got resolved? Please let us know if you need any further assistance.
Thanks,Prashanth Are
MS Fabric community support
- v-prasare
Community Support
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,Prashanth Are