Forum Discussion
Keep points when running get data
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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.