Friday - last edited Friday
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?
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 lieu of a kudo, consider donating to The Buckeye Ranch
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.