Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ShreyasK
Frequent Visitor

Chinese fonts are not visible correctly in PowerBI Dashboard

I have PowerBI dashboard which is uses CSV file as source file. In the CSV file, few column contain Chinese fonts and when I see the same data in dashboard, Chinese fonts are not correctly visible in dashboard visuals. Currently it looks like below - 

子文贺

 

Can you anyone please help and suggest, how we can make this Chinese fonts visible correctly.?

 

 

 

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

It sounds like it could be an encoding issue.

  • When importing from CSV, there is an encoding parameter specified in the 2nd argument of the Csv.Document function, corresponding to the Code page Identifier.
    Power Query tries to detect the correct encoding but doesn't always get it right.
  • Could you post a few examples of the current text displayed in Power BI Desktop alongside the expected Chinese text (in Unicode characters). That may help figure out the correct encoding.
  • When viewing the table in Power BI Desktop in the Data view, does it appear as expected Chinese characters or the meaningless text?

Regards

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

It sounds like it could be an encoding issue.

  • When importing from CSV, there is an encoding parameter specified in the 2nd argument of the Csv.Document function, corresponding to the Code page Identifier.
    Power Query tries to detect the correct encoding but doesn't always get it right.
  • Could you post a few examples of the current text displayed in Power BI Desktop alongside the expected Chinese text (in Unicode characters). That may help figure out the correct encoding.
  • When viewing the table in Power BI Desktop in the Data view, does it appear as expected Chinese characters or the meaningless text?

Regards

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

@OwenAuger - Great ! I chnaged encoding parameter from 

 

1252windows-1252ANSI Latin 1; Western European (Windows)

 

 

TO 

 

20002x_Chinese-EtenEten Taiwan; Chinese Traditional (Eten)

 

And now output results are as expected. Thanks for the solution.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.