Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |