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! 

Please help 🙂

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.

4 Replies

  • 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.

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi i96_md 

    After promoted header, their are one Step added by default "Change Type"
    Please delete the step and try to change data type as Date


    If Solved your requirement, Please mark as SOLUTION

    Thanks
    Pijush

    • i96_md's avatar
      i96_md
      Frequent Visitor
      2 years ago

      Hi PijushRoy, 

      Thakns for your support! 

       

      Here are the steps applied:

      I did unpivoit the columns to have all dates in one line and becasue Power BI reads dates as numbers, they are unpivoted the same way 😥.