Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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. 

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

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      Blurred out sensitive infos.

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

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