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 djbc1986 ,
Have you tried changing the type of your columns in Power BI Query Editor from Decimal to Whole Number?
>Home > Edit Queries
>Select all columns that need Type Change
> Transform
> Data Type: Whole Number
Let me know if that helped.
Cheers,
Robin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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,
- tex628
Community Champion
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.
- tex628
Could work as a temp fix.. Honestly I'm not sure what could cause this but my guess would be on regional settings aswell!