Stale Query Bug

[Anonymous]

When there was an error message after the query was loaded into the model then upon clicking "edit query" again on a table the "No Query Found" error came up which blocks the ability to get back into the Power Query editor in order to fix the original error message. What's the point of this second error message?

[Anonymous]

I should have grabbed a screenshot! The data sources were Excel spreadsheets. Clicking on any of them and clicking "edit query" produced the same results. The original error message had something to do with a formatting issue. But it was strange that it was blocking the "edit query" function to open up Power Query after a simple error message. Do different data sources produce different types of errors in general?

[v-jingzhang]

Hi @Anonymous 

Are you using Power Query editor in Excel rather than in other tools i.e. Power BI Desktop? If so, you can try opening Power Query Editor from Data > Get Data > Launch Power Query Editor. This can let you open it without selecting a specific query. 

If you are not using Power Query in Excel, which tool are you using?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Ah. I am working in PowerBI so that wouldn't work. But there must be another way to get back into the Power Query editor inside PowerBI without RIght-Click on a table then Edit Query. So, good point!

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Yes, go to Home > Transform data. It can let you open Power Query Editor directly. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it.

[v-jingzhang]

Hi @Anonymous 

What is the data source of this query? Can you show a screenshot of the second error message (remove sensitive info)? 

Best Regards,
Community Support Team _ Jing