Forum Discussion
djbc1986
7 years agoFrequent Visitor
Power BI changes integer numbers to decimal from an Excel file.
Hi there I'm kind of new with this tool, and right now I've got this doubt with some numbers that changed into decimals from an excel file. When I open the excel, I see all the number as integ...
- 7 years ago
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
djbc1986
7 years agoFrequent Visitor
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.
tex628
7 years agoCommunity Champion
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