Frequent Visitor
Posts: 3
Registered: ‎04-11-2017

Sql server to dynamics crm to power bi

[ Edited ]

Is possible to read SQL server database objects in dynamic crm,

and to use  dynamic crm as datasource (not sql server),

and get "direct query" thru crm (not sql) on live data?




Super Contributor
Posts: 3,697
Registered: ‎07-11-2015

Re: Sql server to dynamics crm to power bi

You can read objects directly from Dynamics CRM but not sure if that will meet your needs, depends on what SQL Server information you are trying to read. There is a connector and a content pack for CRM. However, I do not believe either of those supports Direct Query.

In Ohio? Check out the Columbus Azure ML and Power BI User Group (CAMLPUG)
In lieu of a kudo, consider donating to The Buckeye Ranch
Posts: 2,195
Registered: ‎03-06-2016

Re: Sql server to dynamics crm to power bi

Hi @sekic,


In Power BI, all supported data sources to use DirectQuery mode can't be used for getting data from Dynamics CRM. See: Use DirectQuery in Power BI Desktop.


Both Dynamics 365 and OData data sources in Power BI desktop to get Dynamics CRM data only support Import mode, as well as Microsoft Dynamics CRM content pack for Power BI.


In one word, it's not possible to get data from the Dynamics CRM to Power BI directly in DirectQuery mode. Regarding the question to read data from SQL Server to Dynamics CRM, please post a thread in Dynamics CRM forum.


Best Regards,
Qiuyun Yu