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...
That is surprising, my friend. Did you happen to re-click the steps from beginning to end, to make sure that the View Native Query doesn't light up? Or perhaps clear the cache?
Oh yeah, you could try Date.FromText, or even just the Parse Date GUI function.
--Nate
I re-clicked the steps, cleared the cache and tried the other functions. However, View Native Query still doesn't light up. Any other ideas?
