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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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
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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.