Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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/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.
I got Same error ....i'm nt able to rectify on that.Kindly help me
@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?
@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.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |