Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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 ch...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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!