Forum Discussion
Query Error - Rows loaded with 1 error
Hi - thanks for the idea. I actually tried that this morning and still got the same message that there was 1 error, even though that step is built into my query.
willnic Try skipping 12million rows in the queries editor and see what the error is?
The error maybe data related (a transformation failed, a calculation overflowed, etc), or can be data size related (server gave up returning data, out of memory, driver failed, quota reach, etc)
If you can skip 12 million rows and load the rest of the data, that typically suggest that you have reached a limit of some sort on the server. Otherwise, you should be able to see what the error is and fix it.
Thanks for the ideas. I think I figured out the issue, and I believe it was related to the server giving up on returning the data.
In case anyone runs into a similar issue... I was pulling in "Full Date" and then converting it from text to the date format within Query Editor. When I would refresh manually through the Power BI Desktop, I noticed it was going much slower than other models I've created (it would load in ~4,000 row batches whereas my other models will load in ~20,000 row batches). I deleted the step where I was changing the data format in Query Editor and refreshed, and it loaded much faster without the error. So I'm guessing the data type conversion was causing it to run much slower, which then in turn was hitting time limits on the server returning the data, causing it to cut off.
I then just changed the data type under "modeling" in Power BI Desktop instead -- much better now.
So long story short, don't mess with the data types in Query Editor if you don't have to. Adjust data types once the data is already loaded from the Query.
Hi,
Thanks for helping out
I too encountered this error.. 'n' no. of queries loaded 9 errors
I appended similarly structured 05 tables.
Loading Individual tables had no problems..no errors. Once I append, this issue started. I homed on to one single table which was source of this issue by trying to append indivdually different tables.
To check if there are any errors in values, I selected all cells (~290 rows and ~20 columns) and did colour scale conditional formatting in excel and found no errors.
Then I deleted half of the rows in the issue table and found reduced errors.
By deleting the rows further, I identified one culprit row. Though all values seemed OK, I manually typed the dummy numbers. I found that in one of the cells, if I wrote whole no. the error was gone after refreshing. I checked all the other table columns and found them to be of format 'whole no.'. So the issue was updation of decimal no. in a format set as whole no.
Rearranged the data, format in all 05 source tables including Appended table and after refreshing no errors reported.