Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Dataflow Refresh Error with accented characters in data

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.

 

 

3 Replies

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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator

      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!