analyze_sharepoint_patterns
Reviews Power BI SharePoint queries to identify which lists and files each query loads, duplicate fetches, full-site enumeration, swallowed errors, shared navigation impact, and hard-coded IDs.
Instructions
SharePoint loading review: which lists/files each query pulls (by
ID), lists fetched by several queries, SharePoint.Files enumerating the
whole site then filtering by name, queries that never reduce columns or
rows, system columns deleted by name, errors swallowed by
try ... otherwise null/false (refresh succeeds with missing data),
the shared navigation table's blast radius, and hard-coded list IDs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance | Yes | ||
| include_row_counts | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||