Dynamics 365 Online Data Connector

[meiwah]

Hi,

I've used the Dynamics 365 Online Data Connector but the data refresh took several hours. When I convert the query to a SQL statement and connect to the underlying SQL Server database, it took around 20 min. Anyone know the reason? I hope Microsoft can review this connector. The inefficiency might lie in how the connector does the joining of tables. 

[v-cgao-msft]

Hi @meiwah ,

Are you running refresh in Power BI desktop?

Based on your description, it seems to be related to query folding. The query folding mechanism is primarily available in connectors for structured data sources. It will optimize the query steps so that some queries are done in the data source. This will speed up the data extraction, transformation and loading time.
For details you can refer to:
Understanding query evaluation and query folding in Power Query

Speed Up Data Refresh Performance In Power BI Desktop Using Table.View

Determine when a query can be folded:
Query folding - Power Query

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[meiwah]

Hi Gao,

I've tried to refresh on Power BI Desktop and Power BI Service, both are quite slow. It took hours. I'm not sure whether it is due to query folding but when I check the last step of my query, the view native query is greyed out. So I think there is no query folding

Thank you very much!