cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 want that Power BI interpret the strings as scientific notation format numbers.

 

How can I do this?

 

thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Yes, I found out that regional settings was the problem.

I switched to ENglish (US) and the problem was solved.

 

THank you anyway. 

View solution in original post

6 REPLIES 6
Highlighted
Community Champion
Community Champion

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":

 

Some old screenshotSome old screenshot

Specializing in Power Query Formula Language (M)
Highlighted
Super User I
Super User I

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

Highlighted
Microsoft
Microsoft

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.

1.PNG


Best Regards,
Angelia

Highlighted

Yes, I found out that regional settings was the problem.

I switched to ENglish (US) and the problem was solved.

 

THank you anyway. 

View solution in original post

Highlighted

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

Highlighted
New Member

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors