question

ThomasBakholdt-2232 avatar image
0 Votes"
ThomasBakholdt-2232 asked eric-msft answered

How to ensure correct encoding when importing parquet files into Power BI

Is there anybody that knows how to ensure UTF-8 encoding when reading parquet files into Power BI? I have trouble reading the Danish letters æ, ø and å, when importing parquet files into Power BI. This works perfectly fine when using a Synapse UTF-8 encoded database.

More specifically which options to set to ensure the encoding using PowerQuery? (https://docs.microsoft.com/en-us/powerquery-m/parquet-document)

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

eric-msft avatar image
1 Vote"
eric-msft answered DanielMartin-6846 commented

We have identified that this is being caused by a bug in the third-party Parquet library we use. They have the bug reported here.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.