Dataflow Refresh Error with accented characters in data

[Syndicate_Admin]

I am trying to import my data into Dataverse using Dataflows. I am not performing any data change operations other than detecting everything as text. One of the column in my data contains accented characters like 'ē' or Ā, etc and sometimes just multiple dots at the end of string like 'Recap.....'. I am using this column as Key column as it has distinct values only which I have verified using Excel. But when I import the same distinct column in Dataverse using this as Key to update the data, it shows me that key with the same duplicate value already exists even when all rows in this column is unique.

[v-yingjl]

Hi @Syndicate_Admin ,

You need to check the encoding of the data source from dataflows before you import it to Dataverse.

About encoding conversion, you can refer:

1. Two methods to display special characters on Power BI dashboards 
2. How to set the csv file encoding? 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Verify that you use UTF-8 or UCS-2 encoding (or equivalent) when importing your data.

[Syndicate_Admin]

Hi there, I have a similar issue as what @chirag10k mentioned. However I am importing my table from a snowflake database and using dataflows to import the data into a dataverse table.  I can see that the row that have special characters are the ones failing. How can I check the encoding behind my dataflow? Is there anything I can do within my PowerQuery to adjust any rows that have special characters?

Thank you for your help!