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.
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.
The random characters should be in Chinese like in the excel file.
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.
Blurred out sensitive infos.
Which encoding are you specifying in the Lines.FromBinary step? (Please enable "Display line numbers" )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.