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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.