Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thx
Solved! Go to Solution.
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
There has been an update to this item. It is possible using a test feature (currently down).
You can read about it here from a blog post or the Microsoft documentation.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.