Check queryfolding Snowflake

[tobny76]

Hi!
I'm trying to see if my query is folding but, I don't get this to work.
https://www.brunner.bi/post/new-ways-to-check-if-queries-fold-in-power-query-1

What am I doing wrong?

let
     Source = Snowflake.Databases(SF_URL,SF_Warehouse,[Role=SF_Role]),
    EDW_Database = Source{[Name=SF_Database,Kind="Database"]}[Data],
    Schema = EDW_Database{[Name="PROCUREMENT",Kind="Schema"]}[Data],    
    View = Schema{[Name="SUPPLIER_INVOICE_DETAILED",Kind="Table"]}[Data],
    Date_From_Filter = Table.SelectRows(View, each [Accounting Date] >= #date(Date.Year( DateTime.FixedLocalNow())-P_Years_Back_Calendar, 1, 1)),
    GetMetadata = Value.Metadata(Date_From_Filter),
    QueryFolding = GetMetadata[QueryFolding]
in
    QueryFolding

[v-achippa]

Hi @tobny76,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue? or let us know if you need any further assistance.
If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @tobny76,

We wanted to kindly follow up to check if the solution provided by the super user's resolved your issue.
If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[lbendlin · Accepted solution]

There are simpler and more efficient ways.  Use the Query Diagnostics to see what is actually going down the wire (ie if your Power Query filters are handed over to Snowflake or not)