Power QueryExercises

Encoding

How characters are stored as bytes in a file. UTF-8 (code page 65001) is the usual choice; the wrong encoding garbles accented letters.

Files saved by older software may use Windows-1252 or another code page; reading them as UTF-8 turns accented letters into symbols like é. The import dialog's File Origin setting chooses the encoding, and Csv.Document accepts it as an option, so the choice is saved in the query.

In the Power Query editor

File Origin in the CSV import dialog, or [Encoding = 65001] in the Csv.Document call.

Learn more

Practise it

Related terms