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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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
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
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
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.