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 facing issues in the Query editor, After doing so many applied steps, each new step seems to take longer and longer to do. to it gets to a point where i'm waiting ages to do something fairly simple, such as replace values. I've unchecked the relationships options, thinking this may help. Perhaps there is too much data shaping involved in my process? Any help would be appreciated. Regards,Mike.

I don't know if this new option helps with issues like this, but worth testing out against this use case... In the latest update there is a new option you can disable so a preview of data isn't generated on the backend every time you make a change.Update blog - Look for the Option to disable data previews in the background or it is further explained in the video at 16:40 Can be found in the Desktop under File - Options and Settings - Options - (Current File) - Data Load - Background Data

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?

I've experienced 2 types of slowness:1) When editing the query2) When executing When doing multiple steps the editing can be slower than the execution itselft. So what I'm doing in these cases is to insert a temporary date-filter as one of the 1st steps which I later remove. This keeps the editing process quick. For certain operations it can also help to use Table.Buffer or List.Buffer: In order to prevent that the same query will be executed multiple times. But as this will prevent query folding, it can means trial and error to see whether it is actually benefitial.

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

I'm having the same issue, even after just 6 or 7 applied steps. I would love to hear if anyone has had a similar issue or any tips.

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

16 Replies

APACK01
Frequent Visitor
10 years ago
I'm having the same issue, even after just 6 or 7 applied steps. I would love to hear if anyone has had a similar issue or any tips.
- MViolette
  Frequent Visitor
  10 years ago
  I've still no further insight into this. Please let me know if you find a way around the problem.
  - sharan1
    Regular Visitor
    10 years ago
    I have exactly the same problem - with very little data it's taking about 10 minutes for each step - even renaming a column is taking ages. Does anyone have any idea how to speed this up?
cwilliams
Helper II
10 years ago
I am having the same issue. I am making simple updates in Query Editor, formatting data in 1 specific column and it could take hours for it to me done.

It seems that the speed has declined with each new version of PowerBI.

I think you have a good point about the number of steps within a query.

I definitely need a resolution soon.

Cheryl, South Florida
- greggyb
  Resident Rockstar
  10 years ago
  Not a solution, but some discussion. Power Query is very aggressive about reloading the query preview. It seems that each additional step can result in re-reading the source and re-applying intermediate steps. If you have expensive query steps or a large data source, I've seen this slowdown. With well-optimized transformations and sufficient disk throughput, I don't see this sort of slowdown.
  - ImkeF
    Community Champion
    10 years ago
    I've experienced 2 types of slowness:
    1) When editing the query
    2) When executing
    
    When doing multiple steps the editing can be slower than the execution itselft. So what I'm doing in these cases is to insert a temporary date-filter as one of the 1st steps which I later remove. This keeps the editing process quick.
    
    For certain operations it can also help to use Table.Buffer or List.Buffer: In order to prevent that the same query will be executed multiple times. But as this will prevent query folding, it can means trial and error to see whether it is actually benefitial.
ianbarker
Helper III
10 years ago
Does anyone have a solution to this yet?
Using Dynamics CRM Online is so painfully slow in Desktop that it's pretty much unusuable.
- MViolette
  Frequent Visitor
  10 years ago
  I've started to try and use a tool called XRM Tool Box, this has a plugin called Power BI Option-Set Assistant. This will map all your option sets for you, massively reducing the number of steps that needs to be taken in Power BI when editing your query. Give it a go. Here's a link to how it works: http://www.gapconsulting.co.uk/news-resources/blogs/entryid/141/xrmtoolbox-the-powerbi-option-set-assistant
Neil_Message
Frequent Visitor
2 years ago
I have just connected Dyanmics 365 CRM to Power BI and I am experiencing issues with being able to edit in Power Query Editor. The slowness hurts.

Is there another thread anywhere that explains how to speed this up?

Forum Discussion

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

16 Replies

Related content

PowerBi Desktop Performance Issues

SQL query editor performance

Tabular Editor with Power BI Desktop

DAX Performance

DAX performance optimization