Forum Discussion

djbc1986's avatar
djbc1986
Frequent Visitor
7 years ago
Solved

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...
Need Help
  • tex628's avatar
    tex628
    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

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

Could work as a temp fix.. Honestly I'm not sure what could cause this but my guess would be on regional settings aswell!

djbc1986's avatar
djbc1986
Frequent Visitor
7 years ago

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.