How do I add a month name column without losing query folding

[Don-Bot]

I currently have an aggregated query that is setup within power query.  I want to add the actual month name so I can do an aggregation to the creation table so that the queries bypass live queries for the end users.  However, everytime I add this in the custom columns I lose the "view native query" option

let
    Source = Ticket,
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Create_Date", type datetime}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Company_ID", "Create_Date" }),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Create_Month", each Date.StartOfMonth([Create_Date])),
    #"Inserted Year" = Table.AddColumn(#"Added Custom", "Creation Year", each Date.Year([Create_Date]), Int64.Type),
    #"Inserted Month" = Table.AddColumn(#"Inserted Year", "Creation Month", each Date.Month([Create_Date]), Int64.Type),
    #"Inserted Quarter" = Table.AddColumn(#"Inserted Month", "Creation Quarter", each Date.QuarterOfYear([Create_Date]), Int64.Type),
    #"Grouped Rows" = Table.Group(#"Inserted Quarter", {"Company_ID",  "Create_Month", "Creation Year", "Creation Month", "Creation Quarter"} ),
    #"Filtered Rows" = Table.SelectRows(#"Grouped Rows", each [Create_Month] >= RangeStart and [Create_Month] <= RangeEnd)
in
    #"Filtered Rows"

Is there a way I can do this with query folding as well?
I add this and the view native query option goes away

#"Inserted Month Name" = Table.AddColumn(#"Inserted Quarter", "Month Name", each Date.MonthName([Create_Date]), type text),

[Anonymous]

Hi @Don-Bot ,

 If you're working within Power BI service and have access to Power BI Premium, consider using Dataflows with the Enhanced Compute Engine (ECE) to maintain query folding. Dataflows are designed to optimize query performance and support query folding even with custom columns. More information on this can be found here:

Develop solutions with dataflows - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.