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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
burrito
Helper I
Helper I

Need help with Chinese characters

Hello, I need help on how to fix this issue. My source file is an xls file and the encoding is already Unicode. However when I use the file in Power BI, it shows below data. 

burrito_0-1707115214817.png

The random characters should be in Chinese like in the excel file.

3 REPLIES 3
lbendlin
Super User
Super User

Please show your Power Query code.  If possible, use .XLSX, not .XLS.

Hi, this is the Power Query code. It's not possible to use .xlsx, we can only use .xls.

burrito_0-1707200170082.png

Blurred out sensitive infos.

 

Which encoding are you specifying in the Lines.FromBinary step?    (Please enable "Display line numbers" )

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors