Using Power BI Report Builder and Dynamics 365 CRM as Datasource

Question

I am trying to connect to Dynamics 365 CRM from Power BI Report Builder. Dynamics 365 CRM option is not available in the datasource.

Please let me know on how to connect to Dynamics 365 CRM datasource.

v-cherch-msft · Answer

Hi&nbsp;Kiran1234&nbsp;
I'm afraid it's not supported yet.Reporting Services paginated reports in Power BI Report Server support the same data sources that are supported in SQL Server Reporting Services. See the list of&nbsp;Data sources supported by Reporting Services.
https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources
Regards,

anonymous · Answer

Has there been an update to this?&nbsp; Can we connect PowerBI Report Builder to Dynamics 365 CDS?

anonymous · Answer

You can build dataset using Common Data Service connection in Power BI Desktop. Publish the dataset in Power BI Webservice. Connect to the Power BI dataset in Power BI Report Builder.

Forum Discussion

Using Power BI Report Builder and Dynamics 365 CRM as Datasource

3 Replies

Related content

Dynamic datasource for Sharepoint

Dynamic datasources are not supported.

Power Bi Report Builder(Paginated Report) Dynamic

Report Builder - Export failed

Dynamic datasource error with relativepath