Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
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

v-jiascu-msft
Microsoft Employee
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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.