Forum Discussion

meiwah's avatar
meiwah
Resolver I
3 years ago

Dynamics 365 Online Data Connector

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. 

General Comment

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      meiwah
      Resolver I
      3 years ago

      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!