percentage values in excel when imported to power bi desktop

[arpitkumar2310]

Hello,

I have an excel table which has two columns containing percentage values. When I imported the dtaa from execl to power bi desktop using "get data", the all the perecentages which were non-zero got converted to 100%. I am uanble to find the reason for the same.

Kindly help. Its urgent.

Thank you.

[v-huizhn-msft]

Hi @arpitkumar2310,

I reproduce your scenario and get expected result.

In excel, there is a table.



Then import the excel table into PowerBI, it shows correctly.



For your issue, please check your data type in excel. And the percentage is resource data or calculated column data? Please share more details for further analysis.

Best Regards,
Angelia

[arpitkumar2310]

Hi Angelia,

The solution was that when we import any table in Power BI it automatically goes for data type identification and in this particular case it didnt do it properly. Hence, I had to remove the changed queries and redone it. The question remains, why it happened in the manner in which we didnt expect powerBI to behave? This happened for the first time with me. It shouldn't have happened.

Thank you for your response.

[v-huizhn-msft]

Hi @arpitkumar2310,

Please save your .pbix file and close PowerBI desktop. Reopen your file and reload it again, check if it works fine.

Best Regards,
Angelia

[arpitkumar2310]

Dear Angelia,

Sorry it didn't worked that way. I had to go to queries, remove the change type and do it again properly.