Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago
Solved

Problem with data type from an excel file

Hello,   I have a simple excel file with a single table that I'm trying to implement to my report. My problem is that one of the colums has number data that power bi recognises as dates. The colum...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mork Go back in Excel and format the column as Fraction - it should then automatically recognize it as numbers

     

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago

Decimal number gives me an error. Only text type show the correct data. Should I keep it as text or try something else?

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

mork Go back in Excel and format the column as Fraction - it should then automatically recognize it as numbers

 

  • mork's avatar
    mork
    Icon for Helper V rankHelper V
    10 years ago

    Thanks a lot!!