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 Qu...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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
8 years ago

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
    8 years ago

    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