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

I tried to play around with the regional settings and here is how it looks, good news I don't see the encoding but still it is not delimitted the way it should.