Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
This did it , thanks!
Glad to help!
Have a good one!
Try "Use Locale"
otherwise close power bi and all office applications then change the system regional settings to ENGLISH US
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