Microsoft Dynamics CRM Connector

Question

Hi,We have Microsoft Dynamics CRM and would like to create datasets / dataflow.What connector should I use?Thanks,John&nbsp;&nbsp;

audreygerred · Answer

Hi! Use the Dataverse connector for Dynamics 365 CRM.&nbsp;Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn

johnpjustus · Answer

Thanks very much. I can see that connector from PowerBI Desktop, however I don't see this in the PowerBI service. I am trying to create dataflow on PowerBI Service and would like to create a connection to Microsoft Dynamics CRM

Any other options?

Thanks,

John

audreygerred · Answer

In your screenshot it looks like you were searching 'dynam', but what you need is Dataverse. When I go to Dataflows I see it as an option:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse

johnpjustus · Answer

Thank you so much.In PBI Desktop, I see few other connectors like below.Do you perhaps know the differences?&nbsp;&nbsp;

audreygerred · Answer

The top one is an old connector that was replaced by Dataverse. I am not sure what the other ones are, but one looks specific to on-prem and another looks specific to customer insights and is in beta. I believe the Business Central connectors are for the ERP side of Dynamics (Dataverse is for CRM side). Anytime I am using Dynamics CRM, I use the Dataverse connector. I use the green one, but the one above it is likely that same, just also searchable through Dynamics.&nbsp;&nbsp;

Forum Discussion

Microsoft Dynamics CRM Connector

8 Replies

Related content

How to Setup Service Principal for Microsoft Outlook 365 Connector?

Dynamics BC connector - NULL error: will Microsoft fix it?

Dynamics 365 connector not including column RegardingObjectTypeCode

Spark connector for Microsoft Fabric Data Warehouse

Dynamic Filter