Azure Blob Encoding issue

Question

Azure Blob Encoding issue

Martin Pesant 11

Hi Folks,

I have a client dropping their CSV file into Azure Blob but when I download the file, everything is good but when I use the edit view, it has wierd symbol. When I use a power automate to get the file content, I also do have wierd symbol

Any hint how to resolve this encoding issue ?

Example : Instead of having : "Régulier" which means Regular, we have Rï¿½gulier

Nasreen Akter 10,891 Reputation points Volunteer Moderator

2022-03-07T18:22:54.023+00:00

Hi @Martin Pesant , are you opening the CSV file in Excel? If yes, you can try to change the encoding while loading the file. hope this will solve the character issue on your local. Thanks!
Martin Pesant 11 Reputation points

2022-03-07T18:30:17.64+00:00

Nah directly into Power Automate :

And directly into Azure Blob :

Why does it matter ? It is causing me some error in Power automate.

1 answer

Your answer

Nasreen Akter 10,891 Reputation points Volunteer Moderator

2022-03-07T18:22:54.023+00:00

Hi @Martin Pesant , are you opening the CSV file in Excel? If yes, you can try to change the encoding while loading the file. hope this will solve the character issue on your local. Thanks!
Martin Pesant 11 Reputation points

2022-03-07T18:30:17.64+00:00

Nah directly into Power Automate :

And directly into Azure Blob :

Why does it matter ? It is causing me some error in Power automate.

Answer 1

Vaibhav Chaudhari 38,971 Volunteer Moderator

I think, you will have to reach out to client team, request them to investigate, use correct encoding and write files to Blob storage. I don't see any way to read this file correctly as it has corrupted characters for special characters.

Somewhat related thread: https://stackoverflow.com/questions/61331729/problem-writing-to-csv-german-characters-in-spark-with-utf-8-encoding

PRADEEPCHEEKATLA 91,496 Reputation points Moderator

2022-03-15T10:08:00.717+00:00

Hi @Martin Pesant ,

Did you get a chance to reach out to client team to resolve the issue?
Martin Pesant 11 Reputation points

2022-03-15T12:50:55.957+00:00

Yeah, he changed it to UTF-8 and now power automate can see accent but I wish there was a way to do the convertion from Datalake or Onedrive.
PRADEEPCHEEKATLA 91,496 Reputation points Moderator

2022-03-16T10:24:23.157+00:00
Hi @Martin Pesant ,

Glad to know that your issue has resolved.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Share via

Azure Blob Encoding issue

1 answer

Your answer