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.

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

1. When importing a csv file, you automatically get a step "Changed Type".

In this step,you need to add a culture that uses a decimal point instead of a decimal comma, e.g. (in the formula bar):

= Table.TransformColumnTypes(#"Promoted Headers",{{"Textfield", type text}, {"Number field", type number}, {"Integer field", type text}}, "en-US")

Specializing in Power Query Formula Language (M)
 
2. A even simpler solution. There is a setting; "Archive - Options and settings - Options - Regional Settings - Locale" which I changed to English (United States).