![]() 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. I homed on to one single table which was source of this issue by trying to append indivdually different tables. ![]() ![]() Loading Individual tables had no problems.no errors. I appended similarly structured 05 tables. Adjust data types once the data is already loaded from the Query. ![]() So long story short, don't mess with the data types in Query Editor if you don't have to. I then just changed the data type under "modeling" in Power BI Desktop instead - much better now. 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 deleted the step where I was changing the data format in Query Editor and refreshed, and it loaded much faster without the error. 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 was pulling in "Full Date" and then converting it from text to the date format within Query Editor. In case anyone runs into a similar issue. I think I figured out the issue, and I believe it was related to the server giving up on returning the data.
0 Comments
Leave a Reply. |