Why reload entire query when I rename a step?

[Wilhelm]

In an already extremely slow environment due to constant reloading of referenced queries, why reload an entire query when I rename a step?  Is there a way to keep that from happening?

[v-yulgu-msft]

Hi @Wilhelm,

Here is a similar thread for your reference, and you can try v-qiuyu-msft's workaround.

Edit queries preview must reload each time a change is made

Regards,

Yuliana Gu

[Wilhelm]

Thanks, @v-yulgu-msft - I had a quick look.  That workaround (the one to refer to the query as source) is how I'm doing all my referencing, and that is the core of the issue. 

When referring to another query, one would expect thát query to load once, and thereafter only being refreshed upon a 'formal' refresh.  While in memory, all referring queries should just draw from the in-memory loaded results - even if it's a subset for preview purposes. 

Waiting on the source to re-poll the SharePoint folder.At the moment, when referring to another query, even something small like applying a filter to a column goes back through the entire chain of referrals, re-running every single one. 

The query on the screen has another query as its source.  The source loads data from SharePoint, but when trying to filter a column from the secondary query, it re-runs the refresh from SharePoint for the original query - this takes ages, and as you can see, even PowerBI gets to a point where it says it's waiting...

[Seward12533]

Don’t think is possible. You can rename the step and just cancel the refresh and live with the warning message.

[Wilhelm]

Thanks, @Seward12533.  Is there a quick way to cancel the refresh that I'm not seeing?

[Seward12533]

Escape works I think. You can also edit your stop names in the advanced editor. You just need to rename both on the line your renaming and then in the next step. I typically do this in Notepad++ or some other code editor. M supports two different types of comments:

Single line comments can be started with //
You can comment out multiple lines or comment out text in the middle of a line using /* */
e.g. = 1 + /* some
comment */