Forum Discussion
Solved
SQL column as Date type format converting to Date/Time during Query Editor Import
Hello all, As stated in the subject I'm having an issue with a SQL column formated as a Date type being recognized by the Query editor as Date/Time. I have already disabled both "Auto date/...
Hi Tgilchrist ,
I found the following answer.
Date format is DateTime only set to midnight.
https://community.powerbi.com/t5/Desktop/Change-datetime-format-to-date-in-SQL/td-p/441602
Is there a solution to this? I am using DirectQuery to pull SQL data. Get the message that I cannot change the data type once the data has been applied because it is DirectQuery, so used Convert (date,dateField) in the query which results in a Date only field in SSMS when checking the results. But in PowerBI insists on adding the 00:00 time element. And I cannot seem to just format the table column to remove the time so looks really untidy.