Forum Discussion

MViolette's avatar
MViolette
Frequent Visitor
10 years ago

Slow performance within Power BI Desktop, Query editor, Applied Steps.

Hi all,   I tried connect to the Dynamics CRM Content pack online without sucess. So now i'm trying to connect to Dynamics through either Power Query or directly with Power BI desktop.   I am fac...
Need Help
cwilliams's avatar
cwilliams
Helper II
10 years ago

I took the above suggestions about resolving the performance of query editor.  It does not seem to make a difference to filter on a specific date when the query has more than 20 applied steps.  Is there a maximum number of applied steps allowed for a query?

 

There were two steps that I used to speed up the query editor process:

 

1)  Unchecked the "Allow data preview to download in the background."  Make sure that this is unchecked in the report view and query editor.

 

2)  The other option that I unchecked was "Enable refresh of this query."  This is located in the Query Editor under Properties.  DO NOT UNCHECK "Enable load to report."....you will lose the report.

 

Let me know if this assists anyone or if anyone has other solutions.

 

Cheryl W.

South Florida

MViolette's avatar
MViolette
Frequent Visitor
10 years ago

Just an update, none of the above suggestions have improved the speed of the applied steps in my query. Any one else able to help?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Is there a feature we can vote to fix this ?

    I am currently working on a complex data model with lots of queries.

    Power BI is slowing down like crazy, every time I have to add a new step or a new query.

     

    I can't make my deadline because of this :smileysad: