Importing excel and date column not working in PBI

[m_roussakis]

I have an excel file I use as source for my dashboard. It has a date column which appears like this on the excel:

When I load it into Power BI the column displays the date in this weird format.

I've tried to change column type to Date/Time but get an error:

Any ideas?

[Anonymous · Accepted solution]

The data is uploaded in this strange format, which actually is not strange, because this is how Power Query deals with data/time type. 
The integer value is the date part and the decimal value is the time part.

In order to workaround, convert the column type to decimal and then, in another step, convert it to date/time format. 

This must work

[m_roussakis]

This did it , thanks!

[Anonymous]

Glad to help!

Have a good one!

[tamerj1]

@m_roussakis 

Try "Use Locale"

otherwise close power bi and all office applications then change the system regional settings to ENGLISH US  

[SergioSilvaPT]

Hi @m_roussakis,

I tried to replicate but Power BI recognized correctly as Date/Time/Timezone on my side, can you please publish a copy of the excel so i can see what could be the problem?

I suspect that i may be the encoding of the excel file.

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.