cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MViolette Frequent Visitor
Frequent Visitor

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 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.

14 REPLIES 14
APACK01 Frequent Visitor
Frequent Visitor

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

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
Frequent Visitor

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

I've still no further insight into this. Please let me know if you find a way around the problem.

sharan1 Visitor
Visitor

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

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 Regular Visitor
Regular Visitor

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

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 New Contributor
New Contributor

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

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.

Super User
Super User

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

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.

 

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Super User
Super User

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

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

 

 


Near SE WI? Join our PUG Milwaukee Brew City PUG
cwilliams Regular Visitor
Regular Visitor

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

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

Highlighted
MViolette Frequent Visitor
Frequent Visitor

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

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?

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 70 members 992 guests
Please welcome our newest community members: