Empty Query Errors

[Anonymous]

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

[Anonymous]

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

[v-jiascu-msft · Accepted solution]

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]

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]

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