Power BI Desktop importing decimal incorrectly for SOME of MS Excel cells

[ErikAcquatella]

Hello Everyone,

I need some help here. I have the following values that you seen in the Excel xlsx Table below and when I import the Table into Power BI Deskptop, unpivot and change the Data Type, I get an incorrect decimal value for only one cell.

i have looked for information already and found an article with exactly the same issue, however the solution will not work for me.

[v-easonf-msft]

Hi， @ErikAcquatella 

You can try changing the data type of the column in excel to ‘Text’, then import the data into PowerBI and change the data type to decimal.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@ErikAcquatella , In case you have unpivoted the months in power bi, Check the data type of April was decimal. And it should be decimal on the very first Change Type step. If not overwrite that step to make all such columns are decimal

[ErikAcquatella]

@amitchandakThanks for the reply. I have changed the Data Type to Number with 2 decimals and imported back to Power BI. Same issue. And happens with other cells as well