Importing data from a Dynamics 365 CRM solution into Fabric

[pmscorca]

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

[v-prasare]

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]

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]

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 

[ToddChitt]

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]

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]

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