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
Tgilchrist: I would actually import those fields directly from SQL as DateTime, and then format the fields to show either or date or time. You will have to do this anyway to get the right format to show when you build the report.
Anonymous as I understand Tgilchrist the problem appears already in Power Query.