Forum Discussion
Stale Query Bug
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.
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?
Community SupportHi 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.
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
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.