topic Re: Importing data from a Dynamics 365 CRM solution into Fabric in Pipelines

Importing data from a Dynamics 365 CRM solution into Fabric

pmscorca — Tue, 15 Jul 2025 16:05:57 GMT

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

Re: Importing data from a Dynamics 365 CRM solution into Fabric

ToddChitt — Tue, 15 Jul 2025 20:46:42 GMT

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.

Re: Importing data from a Dynamics 365 CRM solution into Fabric

pmscorca — Wed, 16 Jul 2025 08:20:26 GMT

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.

Re: Importing data from a Dynamics 365 CRM solution into Fabric

ToddChitt — Wed, 16 Jul 2025 13:29:14 GMT

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

Re: Importing data from a Dynamics 365 CRM solution into Fabric

v-prasare — Mon, 21 Jul 2025 15:34:58 GMT

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

Re: Importing data from a Dynamics 365 CRM solution into Fabric

v-prasare — Thu, 24 Jul 2025 09:59:16 GMT

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

Re: Importing data from a Dynamics 365 CRM solution into Fabric

v-prasare — Mon, 28 Jul 2025 18:23:20 GMT

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

Re: Importing data from a Dynamics 365 CRM solution into Fabric

v-prasare — Thu, 31 Jul 2025 06:49:54 GMT

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