Forum Discussion

i96_md's avatar
i96_md
Frequent Visitor
2 years ago
Solved

Help! Power BI reads dates from Excel as numbers

Hi All, 🙂  When I import data from my Excel workbook, Power BI reads the dates as numbers, see below Tried to change the data format to Date and to play with the locale, but no luck!  Pleas...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    Hi i96_md 

     

    First change the datatype to number since it is being imported as a string.  (as in original post)

     

    After that you should be able to change the type to date.  It will ask if you want to replace the current step or create an additional step.  Select Additional step.

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi i96_md 

 

First change the datatype to number since it is being imported as a string.  (as in original post)

 

After that you should be able to change the type to date.  It will ask if you want to replace the current step or create an additional step.  Select Additional step.

i96_md's avatar
i96_md
Frequent Visitor
2 years ago

Many thanks gmsamborn! It worked ðŸŽ†