Hi all! I've been developing powerqueries and exporting them for the last few months with no problem. However, I ran into a weird occurrence this morning.
I have a powerquery that when directly run against the Powerschool database, returns exactly what I expect. However, when the exact same query runs as a scheduled tsv export, it flips the data in two of my columns. Specifically, the 'City' column has flipped info with the 'Country' column (State remains unaffected!)
Any idea what could cause this behavior?
For us to assist you further, would you please confirm if exporting as csv file or excel has the same behavior?