Forum Discussion
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)....
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,12840098I removed the "" from 1st 2 rows of the data and again saved the csv file. This workaround actually resolved my issue.
