We can't automatically convert the column to Whole number type.

[harirao]

Hi All,

Can you help me on this, I have a column of numbers that was imported from Excel, showing as text in power bi. when i try to change Date Type to Whole number getting below error.


 

Thank you

[JessicaRohrer · Accepted solution]

You likely need to change it in PowerQuery editor than in the Table View. Can you try transforming to whole number in PowerQuery editor and post a screenshot if that doesnt work?

[Anonymous]

Thank you Jessica - this just solved my current issue as well 🙂

Yx