Help! Power BI reads dates from Excel as numbers

[i96_md]

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 🙂

[gmsamborn · Accepted solution]

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]

Many thanks @gmsamborn! It worked 🎆

[PijushRoy]

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]

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