Forum Discussion

Gertjan's avatar
Gertjan
Frequent Visitor
4 years ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Instead of Table.TransformColumnTypes, go back and make it Table.TransformColumns, and replace "type date" with "Date.From". Basically using Date.From to transform instead of changing types.

 

--Nate

Gertjan's avatar
Gertjan
Frequent Visitor
4 years ago

Thanks Anonymous, the query itself works, however it still doesn't allow to view native query. Any other solution?

 

 

  • AlexCod's avatar
    AlexCod
    Frequent Visitor
    2 years ago

    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.