Direct query - Remove time for date column

Hello Syndicate_Admin

I guess you already found out by the date of your reply. I have had the same problem with DirectSQL and I have managed to solve it without getting the famous message of "This table uses DirectQuery and you can not ..."

The fact is that this message does not come out when you DUPLICATE the column, but when you TRANSFORM to "date only" format. Therefore, what I have done to achieve this is to DUPLICATE the column (in my case SeatDate) and renamed it to SeatDate - DDMMAAAA.

Then, outside the powerquery editor, in the PowerBI Desktop editor, I click right on the column created SEATDATE - DDMMAAAA and above all, in format, I scroll and select in "Common Formats" the second option, which is called (ShortDate).

In this way I have managed to get a date that is, for example, "23/04/2021 13:30:45", to a date that remains only "23/04/2021". Thus allowing you to continue with your analysis.

Sorry for the delay, I started with PowerBi recently.