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...
Hi Gertjan ,
In Power Query, Text -> all transformations would break query-folding.
Changing data types that do not break query-folding in Power Query / Power BI
Please try using sql statement in query.
let
Source = Sql.Database(".", "CaseTest", [Query="select #(lf) CAST( [Date2] AS date) [Date],#(lf) [Value] as [Rename_Value]#(lf)from [dbo].[Test1$]"])
in
Source
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your suggestion. However, it still doesn't allow me to view native query.
Maybe it's just not possible?