Help

Powerquery does not match tsv export

Weg8k
Journeyman

Powerquery does not match tsv export

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? 

1 Reply
KritiS
Community Support Expert
Community Support Expert

Hi @Weg8k 

 

For us to assist you further, would you please confirm if exporting as csv file or excel has the same behavior?



KritiS
Community Moderator

Remember to give Kudos to suggestions that help you!
If a suggestion helps solve your issue, please select Accept As Solution on the post so others can see the solution, too!