Forum Discussion
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.
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!
5 Replies
- v-kelly-msft
Community Support
Hi Anonymous ,
Check the blog below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- AnonymousNot applicable
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
Community Support
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,
KellyDid I answer your question? Mark my post as a solution!