Forum Discussion

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
7 years ago
Solved

Azure Blob read with encoding utf-8

Hello, I have a list of csv files in azure blob that I combine and import into power BI. I am successfully able to import the files. But, the files in the blob are encoded in utf-8 and I would l...
Need Help
  • purnima13's avatar
    purnima13
    7 years ago

    This is what finally worked for me.
    I just combined the binary files in this way.
    When you click on the downward arrow in content to combine the files. It takes a sample file and asks us to choose the encoding.
    This made it easier and the output is correctly encoded with utf8

    combine files from the content column

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

purnima13 ,

 

You can add a step using Text.FromBinary function.

 

Text.FromBinary(binary as nullable binary, optional encoding as nullable number) as nullable text

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.