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'm having this issue. Quite why it would be acceptable to change the number to something different is bizarre. Its recorded as 1.1 in Excel. This is doing it for only certain numbers in the single decimal place number range. I have even set the cells in Excel to Text type and it still reads it (and incorrectly displays it) as a 15-dp number.