Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Stale Query Bug

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...
General Comment
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.