Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Does anyone know if IBM Netezza supports query folding?
I'm trying to build a dataset with incremental refresh with Netezza as the source, but the 'view native query' option is greyed out in Power Query.
Here is my code:
let
Source = Netezza.Database("XXX", "XXX"),
LIVE = Source{[Name="LIVE"]}[Data],
DIMDATES1 = LIVE{[Name="FM_V_RETAIL_MODEL_FACT_AGG1"]}[Data],
#"Filtered Rows" = Table.SelectRows(DIMDATES1, each [DATE_TIME] >= RangeStart and [DATE_TIME] < RangeEnd)
in
#"Filtered Rows"
Thanks
Mike
Hi @Anonymous ,
As @mwegener has said, if the data source can support Direct Query, itself can support query folding, because For a DirectQuery or Dual storage mode table, the Power Query query must achieve query folding, and the IBM Netezza can support direct query based on this document.
But we noticed you are using incremental refresh in Import Storage mode, if you make a complate query, some sub-query may not support query floding even the source can support, but there are only some transformations in power query editor can be query floded based on this documnet.
In most cases, we can use View Native Query option to determine when a Power Query query can be folded, But based on this document, The View Native Query option is only available for certain relational DB/SQL generating connectors. It doesn't work for OData based connectors, for example, even though there is folding occurring on the backend. In additional, If the View Native Query option is not enabled (greyed out), this is evidence that all query steps cannot be folded. However, it could mean that a subset of steps can still be folded. Working backwards from the last step, you can check each step to see if the View Native Query option is enabled. If this is the case, then you have learned where, in the sequence of steps, that query folding could no longer be achieved.
At last, based on this document, If you want to check that the necessary query folding is occurring, you can use the Query Diagnostics feature, or trace queries received by the source database.
Best regards,
Hello all,
Thanks for the responses. The source allows a direct query connection so I'm not sure why the 'view native queries' is greyed out.
We will try to track the query at the source.
Thanks
Mike
Hi @Anonymous ,
I think if DirectQuery is supported, query folding is also supported, because in both cases the data is already filtered in the source.
Can you track the queries on the source?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |