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

[Anonymous]

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. 

EDIT: Is there anybody that knows which options to set to ensure the encoding using PowerQuery? (https://docs.microsoft.com/en-us/powerquery-m/parquet-document)

Thank you in advance! 

[v-kelly-msft]

Hi  @Anonymous ,

Check the blog below:

https://techcommunity.microsoft.com/t5/azure-synapse-analytics/always-use-utf-8-collations-to-read-utf-8-text-in-serverless-sql/ba-p/1883633

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @v-kelly-msft 

Yes, that works. But my question is more related to reading parquet files directly into PBI, and thereby avoiding a synapse ressource. 

[v-kelly-msft]

Hi @Anonymous ,

Sorry for the misunderstanding,check below blog for the steps below:

https://www.red-gate.com/simple-talk/blogs/power-bi-reading-parquet-from-a-data-lake/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @v-kelly-msft 

Thank you for your answers. However, this guide doesn't help with changing the encoding in order to keep the Danish letters, which is my problem. 
I have no problem reading the actual data into PBI. However, I have trouble with encoding. 

[v-kelly-msft]

Hi  @Anonymous ,

Sorry for the late reply.

Below is the reference about encoding of UTF-8:

https://en.wikipedia.org/wiki/UTF-8

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!