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

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?