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.
     

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
4 years ago

The settings to change have to do with the File Origin box.  But without knowing anything more about your csv file than the screenshot you shared, it's not possible to tell you how to change it.  

 

You could try a trial and error approach; or you could provide more information about the csv file.