Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 want that Power BI interpret the strings as scientific notation format numbers.
How can I do this?
thank you!
Solved! Go to Solution.
Yes, I found out that regional settings was the problem.
I switched to ENglish (US) and the problem was solved.
THank you anyway.
I tried the answers in this post but still get errors after changing the language to en-US
My numbers are in the format three digits E+single digit
like 303 E+3
or 97.6 E+3
what else can I do to not get Errors displayed?
Thanks for your help
Hi @rmx000000,
After test, I can change it to decimal number as follows. Please update your Power BI desktop to the latest version and check if it works fine.
Best Regards,
Angelia
Yes, I found out that regional settings was the problem.
I switched to ENglish (US) and the problem was solved.
THank you anyway.
Hi @rmx000000,
Congratulations, you have resolved your issue, please mark the right or helpful reply as answer, so more members like you will get help from here. Thanks for understanding.
Best Regards,
Angelia
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
Probably your culture code expects decimal commas. In that case, you need to provide a culture code when transforming to number type, e.g. "en-US":
= Table.TransformColumnTypes(NameOfYourPreviousStep,{{"column A", type number}, {"column B", type number}}, "en-US")
This can be done by using "Using Locale":
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |