Loaded Query contained error - How to find the errors and solve the issue

[Anonymous]

Hi Everyone,

I have a dashboard that has many tables and while refreshing there is message saying "1 Loaded query contained error", when I click View Errors it takes me to the power query editor and shows nothing - all blank. Now, how do I know what are the errors?

Appreciate any help 

[Raja10ram]

I got Same error ....i'm nt able to rectify on that.Kindly help me

[anil_kathane]

@Anonymous How did you find that the error is due to calculation resulting in NaN values? I am not sure how to locate the error when I have a dataset with thousands of records and some 25+ columns. Can you please guide on that?

[v-yuta-msft · Accepted solution]

@Anonymous ,

In power query-> "remove rows" section, click remove errors and check if error disappeared. 

 

In addtion, it seems this issue should be related to data format can't be recognized by power query, I would suggest you to refer to this thread: https://community.powerbi.com/t5/Desktop/error-message-after-building-query-returns-zero-rows-in-the...

Community Support Team _ Jimmy Tao

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

[Anonymous]

Thanks for the reply @v-yuta-msft 

I tried this before and didn't wotrk for me. I used another method which is kind of time consuming but it worked. 

Some calculations that I used in the query resulted in "NaN" and "Infinity" in some cells which were actually the errors. Not sure why BI wouldn't point that out (may be a bug as everytime I clicked on the errors it showed me a blank query). 

Solution

So, what I did > converted the columns to "text" from decimal # in the query editor and then replaced values (NaN, Infinity) with Blank. and then converted the columns back to decmal # and saved it. Now when I refresh my datasets it doesnt show me any errors anymore. 🙂

Thanks again.