How can we stop Reordered columns in power query? challenging when dealing with large data sets

[Anonymous]

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: 1 of the loaded queries contained errors

The error was a forced Reordering columns by Power Query.
How can I avoid this? I have already cleaned up the data in Tableau PREP

Thank you for your responses

[Anonymous]

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

[Omid_Motamedise]

Can you share the picture of error?