Powerquery doesn't Asian language csv problem

Hi All,

Is there anyway to tell Power Query to use UTF-8 Encoding when importing CSV data?

When traditionally import CSV, there will be an option to specify the encoding, but can't find this option in Power Query, or it should be done via coding?


December 25th, 2014 6:25am

Power Query tries to infer the encoding when you open the file, but it may get the wrong answer. In the column of "Applied Steps" in the editor, the first step will usually be "Source" and there should be a gear icon next to that. If you click on the gear, you'll be given the option to change the encoding.
Free Windows Admin Tool Kit Click here and download it now
December 29th, 2014 5:12pm

Same problem here. But when I click in the gear next to "Source" there is no such a thing as encoding options. It only prompts me to choose the file location...

Trying to change in the advanced editor, but it always gives me an error saying that doesnt recognize the encoding I`m typing. And we are talking here of UTF-8 and Latin1...

July 11th, 2015 12:26am

You should see this:

Free Windows Admin Tool Kit Click here and download it now
July 11th, 2015 1:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics