Forum Discussion
Advocate IIs this normal? Date column shows as datetime in Fabric UI
Is this expected?
Screenshot from Fabric Lakehouse UI
Same data from Fabric PySpark Notebook:
And schema:
Why is this?
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.
7 Replies
- lbendlin
Super User
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.
frithjof_vCommunity Champion
Interesting. 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 ...