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: 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
2 Replies
Can you share the picture of 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 TeamIf 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
