Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

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/td-p/159635

 

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.