question

MartinPesant-2633 avatar image
1 Vote"
MartinPesant-2633 asked PRADEEPCHEEKATLA-MSFT commented

Azure Blob Encoding issue

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

azure-data-lake-storage
· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

nasreen-akter avatar image nasreen-akter ·

Hi @MartinPesant-2633, 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!

0 Votes 0 ·
MartinPesant-2633 avatar image MartinPesant-2633 nasreen-akter ·

Nah directly into Power Automate :



180715-image.png


And directly into Azure Blob :

180771-image.png


180760-image.png

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


0 Votes 0 ·
image.png (51.0 KiB)
image.png (89.1 KiB)

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered PRADEEPCHEEKATLA-MSFT commented

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

· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT ·

Hi @MartinPesant-2633,

Did you get a chance to reach out to client team to resolve the issue?

1 Vote 1 ·
MartinPesant-2633 avatar image MartinPesant-2633 ·

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.

1 Vote 1 ·
PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT MartinPesant-2633 ·

Hi @MartinPesant-2633,

Glad to know that your issue has resolved.

  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·