Desktop Refresh Error: Query "references other queries or steps ... "
For what it's worth, I'd like to give you an update from what I have noticed to hopefully save some of you some time:
I already seem to be able to refresh my report in Power BI Desktop as soon as I have clicked the table mentioned in the error in the power query editor. There seems to be no need to wait until the editor has finished refreshing. It seems to take a little bit longer to start (and when it mentions two different tables in the error, like I have in one of my reports, you seem to need to click them both), but it does start then. There seems to be no need to wait for all the errors / questionmarks to disappear first.
I have tried this on two different reports that always need to be refreshed first in the power query editor (the editor can take up hours sometimes - I know, I might be able to speed this up with a debugging flag), before being able to run a regular refresh in power bi desktop, so for me this is a huge timesaver.
Maybe unrelated, but I'm just wondering if any of you also suffer the issues below (I occasionally have these in the same reports that I have the refreshing problems with):
- in the query editor a specific query (and consequently all depending queries) sometimes just refuses to give me any results of query steps anymore, the window just stays blank. These can be simple queries, that would normally have shown their data within a few seconds. While other queries (unrelated to this one) will still show their data, this one query just won't, until I close and reopen the query editor (or maybe after a ludicrous amount of waiting, but I haven't had the patience nor time to wait that long).
- "Apply changes" blocks with some queries stuck on "waiting for other query" and other queries with "Evaluating" (until I click cancel and then apply changes again). After that it always works the second time.
Both these issues feel very related to the problem above, but then again, they might be a coincidence.
Cheers,
Niels