Forum Discussion

rmx000000's avatar
rmx000000
New Member
8 years ago
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...
  • rmx000000's avatar
    rmx000000
    8 years ago

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

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

     

    THank you anyway. 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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

  • rmx000000's avatar
    rmx000000
    New Member
    8 years ago

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

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

     

    THank you anyway. 

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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