Forum Discussion
Power BI changes integer numbers to decimal from an Excel file.
Check the regional settings in PBI desktop and language settings on your PC. There might also be regional settings in excel. Make sure that they are all in sync.
/ J
Hi Anonymous
Yes I have. I tried with some columns but I was getting wrong numbers. For example, on the first register before making the change I was watching 5,762, but after that I've got 6.
That is why I wonder if maybe I have to modify something with my regional configuration.
Regards,
Go into the query and remove the step that converts them to decimal in the beginning. Instead try formatting them to text, and then into integers as a new step.
Could work as a temp fix.. Honestly I'm not sure what could cause this but my guess would be on regional settings aswell!
Hi tex628
Thanks for your replay. I did something like that. However, I have a large number of columns, and I was trying to avoid to modify each one of them.
Check the regional settings in PBI desktop and language settings on your PC. There might also be regional settings in excel. Make sure that they are all in sync.
/ J