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.

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 ðŸ˜¥.