Skip to main content

Reporting pack

Every build ships build/reporting/ — the analysis surface for the deployed lists.

Contents​

  • One Power Query (M) file per list, plus dictionary, model-info and user-added-column audit queries. Point the queries' SiteUrl parameter at the deployed site and load them in Power BI or Excel.
  • sql/views.sql — a SQLCMD views script for warehouse-landed copies of the lists.
  • REPORTING.md — includes the Power BI relationship table (which columns join which lists, matching the declared lookups).
  • data-dictionary.md — every list and column with types, descriptions and enum values, generated from the same schema the deploy used.

Schema-only reports​

dbml-sharepoint report emits the same queries without needing a site URL (layout: powerquery/, sql/, REPORTING.md, DATA-DICTIONARY.md) — useful for warehouse or BI work that starts before any site exists. See the CLI reference.