Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Empty Query Errors

Hello,

After executing "Close & Apply" in Power Query, I get an error message in Power BI which announces that there are 84 errors in one of my queries.

I then go back to Power Query and finds a Query Error group which contains nothing! Zero rows.

 

 

What is happening?

 

Thank you,

Tamir

  • Hi Tamir,

     

    Were there errors in the original queries? Can you share the file? Please click the last step in the Query Editor and make sure it's good in this place.

     

    Best Regards,

    Dale

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Tamir,

     

    Were there errors in the original queries? Can you share the file? Please click the last step in the Query Editor and make sure it's good in this place.

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable

      HI v-jiascu-msft

       

      I cannot send a sample but you gave me the idea how to check and debug my query.

       

      I traced back the steps until I found the culprit :-)

       

      It still does not answer my question as to why I get errors but the table seems to be empty...but...I don't have errors anymore, so...all is good :-)

       

      Regards,

      Tamir

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Tamir,

         

        That's great. The reasons why you get errors vary from case to case. So it's hard to say without file and the environment. It works again anyway.

         

        Best Regards,

        Dale

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Tamir,

     

    I have the same issue in my report. After close and apply its showing 148 errors in one of my query but none in the query editor.

    You have any solution for this. How to get rid off query errors group?

     

    Thanks