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
Community 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.

  • tex628's avatar
    tex628
    Community Champion
    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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi djbc1986 ,

    I think the reply of tex628 should be helpful.

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share some data sample so that we could copy and test on it.

    In addition, please check if you have installed the latest version of power bi desktop.

    Best  Regards,

    Cherry