Forum Discussion
Direct Query - transform Date TIme to Date
Hi martijnth,
Could you have tried use the measure with FORMAT function? Based on my test, it could work on my side:
You can use the Format function in DQ mode if you go to Options -> DirectQuery and click "Allow unrestricted measures in DirectQuery mode". Note that this will enable other functions whose performance is poor in DirectQuery mode, so save often.
Regards,
Daniel He
well i actually solved it by using a native querry in SQL, something like
SELECT FORMAT (getdate (), 'dd/MM/yyyy ') as date
or look here:
https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
u use this command like:
than it works. Good luck
I dont have access to the database and was looking into implementing this change using power query customr column