Forum Discussion

simmi21's avatar
simmi21
Frequent Visitor
4 years ago
Solved

When connecting to a csv source, data shows wrongly encoded

Dear team,    I have been using csv source for many of my reports untill today for one of the csv file, I am getting encoded data. I read online about the data having special characters could cause...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi simmi21 ,

    When testing with the sample data you have provided, seems like it works fine in Power BI:

    The .txt file also works:

     

    Perhaps you can re-create a txt file with data to try to connect it in Power BI to check, then change to .csv file to re-connect to check it again.

     

    If the data just show one column in the navigator, you can click transform data and split by delimiter as @ AlexisOlson manually, use the first row as the header.

     

    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.
     

simmi21's avatar
simmi21
Frequent Visitor
4 years ago

yes, now its is unencoded but all in one column, the delimtter (which in my case is a semicolon ) is not working. This is how it is coming now :

 

 

 

ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

Perhaps what looks like a semicolon is not a semicolon, but another character that appears similar. Can you please examine the characters to ascertain exactly what the character code is?  You can do this in Excel with the UNICODE function; or using a Hex editor on the file.