Forum Discussion
Solved
Reformat datetime to only date
Hi everyone I have a table coming from sql server that is a datetime. In PowerBI I only want date not time. How do I fix this? The data is being displayed in a PowerBI table: Thank you
You can also try another option using the sql query
SELECT CAST('Datetime column' AS Date) AS ConvertedDate from Tablename
mj2024 Have you tried this solution.
If you found this answer helpful:
Mark it as the solution to help others find it faster.
Thank you everyone.
I am getting an error when I try to change the type:
I do not want to import the data because that is going to make my PowerBI file too big. I prefer the query approach.
I changed the source sql query to say yet PowerBI keeps on adding the time:
CAST(EARNINGS_DATE AS date) AS EARNINGS_DATEAny ideas on how to fix this?
Thank you
