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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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