Forum Discussion
Change date type without losing native query
Hi there, I have a table with two columns: item and date. There are four applied steps in the Power Query: Source, Navigation, Renamed Columns and Changed Type. Date is initially formatted as t...
Thanks Anonymous, the query itself works, however it still doesn't allow to view native query. Any other solution?
Not sure if you still searching for a fix, however this is how i did it.
Use this in the SQL statement " CONVERT(DATE, t.[SHIPDATE], 103) AS 'Shipment Date' " (use your column names )
It will automatically recognise the column as Date/Time
And you do not need the "Changed Type" step that blocks the Native Query:
And after that, just change the format to "Short Date" from the "Table View"
And you can use the column in a relashionship with another table.
And because you are not breaking the Native Query, you can use the "Incremental Refresh" as well without the warning of not being able to fold.