Forum Discussion

XaviOV's avatar
XaviOV
Helper V
6 years ago
Solved

Keep points when running get data

Hi, When I run Get Data from Excel online, numbers that have decimals with "." (point), delete the point. How can I solve this problem? Thank you!
General Comment
  • dax's avatar
    dax
    6 years ago

    Hi XaviOV , 

    I think this should be related to your language. When you load the Excel in powerbi, this will convert type to numberic type and your language will use "."  as thousand separator, ","  as demical separator. so it ("." )will disappear. You could view to my image(I use English(US) language, I have the opposite situation ) 

     You could try to change type like below to see whether it work or not

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

edhans's avatar
edhans
Community Champion
6 years ago

Can you clarify what you are seeing XaviOV ? Excel Online doesn't have a Get Data function. And spreadsheets generated or edited in Excel Online are just XLSX files, nothing unique about them.

 

And when you say the decimal is removed, is 123.45 becoming 123 or 12345?

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    I cannot really tell what you are referring to here XaviOV - I don't know which is the before or after image. You can post images in this forum using the Camera icon. Please use that and describe what each image is.

     

    And what do you mean "upload to power bi?" Is this in the service, or when importing via Power BI Desktop? Please let us know the exact steps you are going through to get the results you are seeing.

    • XaviOV's avatar
      XaviOV
      Helper V
      6 years ago

      Hi edhans ,

       

      Attached images with explanation.
      Regards,

      Xavi

      This is the Excel file (local), and the numbers contain "." decimals.
      Excel file (local file)

      This is when I upload the Excel file into Power BI, you can look that the "point" are disappear.
      Power BI

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi XaviOV , 

        I think this should be related to your language. When you load the Excel in powerbi, this will convert type to numberic type and your language will use "."  as thousand separator, ","  as demical separator. so it ("." )will disappear. You could view to my image(I use English(US) language, I have the opposite situation ) 

         You could try to change type like below to see whether it work or not

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.