Forum Discussion
Advocate IIs this normal? Date column shows as datetime in Fabric UI
There is no such thing as a Date data type. Everything is always DateTime. When you ask for "Date" Power BI and Fabric will give you a DateTime value pegged at midnight UTC.
Super UserThere is no such thing as a Date data type. Everything is always DateTime. When you ask for "Date" Power BI and Fabric will give you a DateTime value pegged at midnight UTC.
Community ChampionInteresting. Could you reference to some docs which explain this?
I still think it's a bad user experience to show the 12:00:00 AM in each cell when the data type is set to Date in the delta table.
It adds cognitive load to the user.
- lbendlin
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types#datetime-types
Wait until you learn about Int128 ...
- frithjof_v
Nice, thanks for sharing!
I'm curious to learn about the Int128 case!
However, the OP is showing the Lakehouse explorer, not a Power BI semantic model. So I'm not sure if the Power BI documentation is relevant for this case.
And OP has shown that the data type is date (OrderDate: date (nullable = true)).
So it seems that the Lakehouse explorer is formatting date type as date/time?
- lbendlin
They use the same/similar engine, so they are constrained to the same data types.
Wait until you learn about how DateTimeZone is represented 🙂