Forum Discussion
Solved
scientific notation
Hi, I have a csv file with two columns : column A, column B 1.5554E-43, 4.2039E-45 Power BI assumes that both columns are strings. If I change them to number, it gives an error. I...
Yes, I found out that regional settings was the problem.
I switched to ENglish (US) and the problem was solved.
THank you anyway.
This might be fixed if you go into the query editor and see what automatic transformations Power BI makes when you import them - if you eliminate the step where it's thinking they're strings, then hopefully you can define your columns to be decimal numbers at the outset and have Power BI correctly interpret your data