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 ...
bug still exists,
first partial solution would be to add a step at the Power Query data model as follows:
it won't solve an issue as convert 1.1 and 1.10 - these two values will transfered to value of 1.1 😐
= Table.TransformColumns(#"<MyLast step name>", {{"MyValue", each try Text.From(Number.Round(Number.From(_),2)) otherwise Text.From(_), type text}})
second partial solution (need to edit the Excel at the source) - add ' at the orignal excel before the value and it will fix it when importing the data to power bi -when transfer the value type to text it will dispalyed correctly