Forum Discussion
How can we stop Reordered columns in power query? challenging when dealing with large data sets
Hello All, (if there is a solution to this question, please reply back with the link - Thank you!) Dealing with a large data set/Postgre SQL SLA Table Refreshing data sets always create the error...
Hi Anonymous ,
In most cases these errors are caused on datatype. Power BI tries to identify you datatype using the first x rows. Then the transformation is applied. If on row x+1 this conversion is not possibile then you have an error.
Try checking the Column Quality and check those columns that have errors.
Solved: Loaded Query contained error - How to find the err...
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum