Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue while importing CSV file

Hi,   I am facing a strange issue while importing a csv file into Power BI. The delimiter of the csv file is “,” (comma), whereas there are few column values with decimal numbers (for example 0,5)....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    Thank you for helping with this issue. As I mentioned that the problem is occured only with 1 csv file. So I found out that there was no issue with the file settings. Therefore I opened the problemetic csv file into notepad(open with notepad) and the data was represented something like below :

    "2020-05-01,ABC,28948349049,260,true,""0,5"",12840098"
    "2020-05-01,DEF,3627287129,205,true,""0,5"",12840098"
    2020-05-01,XYZ,1682732804,205,true,1,12840098
    2020-05-01,teuuey,628728260,16,true,1,12840098
    2020-05-01,kslkapwo,632872899,265,false,0,12840098

    I removed the "" from 1st 2 rows of the data and again saved the csv file. This workaround actually resolved my issue.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Thank you for helping with this issue. As I mentioned that the problem is occured only with 1 csv file. So I found out that there was no issue with the file settings. Therefore I opened the problemetic csv file into notepad(open with notepad) and the data was represented something like below :

"2020-05-01,ABC,28948349049,260,true,""0,5"",12840098"
"2020-05-01,DEF,3627287129,205,true,""0,5"",12840098"
2020-05-01,XYZ,1682732804,205,true,1,12840098
2020-05-01,teuuey,628728260,16,true,1,12840098
2020-05-01,kslkapwo,632872899,265,false,0,12840098

I removed the "" from 1st 2 rows of the data and again saved the csv file. This workaround actually resolved my issue.