analyze_folding_risk
Estimate query folding risk per Power BI query by identifying SQL pushdown steps, the first step that stops folding, late row filters, Table.Buffer, and cross-source merges for M code review.
Instructions
Static estimate of query folding per query: which steps normally push down to SQL, the first step that stops folding, row filters that run locally AFTER folding ended (the source sent every row first), Table.Buffer, and merges across different sources (joined locally). SharePoint/file sources never fold. It is an estimate from M text, not proof: confirm with 'View Native Query', and use read_mashup_traces for the engine's own folding-failure reports.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance | Yes | ||
| include_steps | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||