I am trying to import a mixed (number and text) column from Excel into PowerBI, due to the start of the column all being numbers PowerBI has chosen the column type as numeric. However when I change ...
I've got response from the Product Team.
Instead of changing the type again, the customer should delete the previous type conversion to number by editing the automatically-generated formula that changes the type the first time.
When you enter a "1.1" into a cell, Excel actually stores it as follows: <row r="2" x14ac:dyDescent="0.25" spans="1:1"><c r="A2"><v>1.1000000000000001</v></c></row>
So you can see that we're accurately showing the value stored by Excel even though it differs from the value displayed by Excel.
As a workaround, you can split column as following screenshot.
Best Regards,
Herbert