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 the Power Query editor in order to fix the original error message. What's the point of this second error message?

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.

5 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      v-jingzhang
      Community 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!