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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Is it switching it to Whole Number versus Decimal Number? Check your Change Type steps.

 

Otherwise

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".