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.
     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Can you provide a CSV sample (keep it small and cut out anything sensitive) that we can reproduce this with?

simmi21's avatar
simmi21
Frequent Visitor
4 years ago

 Here how the sample data looks 

Period (months);"Vehicle Units";"Vehicle Build Region";"Vehicle Brand";"Vehicle Model (CA)";"Price Class";"Vehicle Dev.-Code";"Version";"Period (quarters)";"Period (semester)";"Period";"Market Volume";"Region";"Global Region";"Planning Region";"Customer";"Customer Group";"Vehicle Model ";"Region (sales)";"Global Region (sales)";"Planning Region (Sales)";"Division";"Vehicle Segment";"Vehicle Model";"Conti Volume";"Article Code";"Article Description";"efg";"Sales";"Production Plant";"Rim"
1;4173;"CHINA";"abc";"qwer";;"abc;"2021 FC 00+12";"Q1";"H1";"2021-01-01";205;"CHINA";"APAC";"CHINA";"CHINESE OEM OTHER";"CHINESE OEM";"SEV00h";"CHINA";"APAC";"CHINA";"xyz";"";"";0;"";"";0;0;"";""                               
1;27873;"INDIA";"pqr";"rewq";;"abc";"2021 FC 00+12";"Q1";"H1";"2021-01-01";139;"INDIA";"APAC";"INDIA";"OTHER KEY ACCOUNTS";"OTHER KEY ACCOUNTS";"DOST";"INDIA";"APAC";"INDIA";"xyz";"";"";0;"";"";0;0;"";""                              
  • v-yingjl's avatar
    v-yingjl
    Community Support
    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.