Skip to content

BI for SCCM documentation

BI for SCCM documentation

BI for SCCM turns Microsoft Configuration Manager data into clear, actionable Power BI reporting, deployed entirely inside your own tenant. Use these guides to install the app, set up the Power BI Gateway, configure database access, connect your semantic model, and keep your reports current.

BI for SCCM is a Power BI reporting solution that runs entirely inside your own Microsoft tenant. There is no external data egress: all compute, data, and identity stay in your environment. The app connects to your ConfigMgr SQL database through the Power BI Gateway, then surfaces hardware inventory, software deployment, compliance, and OS deployment reporting through curated Power BI report pages. No middleware and no agents: your data stays in your Power BI workspace, governed by your Microsoft 365 tenant policies.

  • Get Started walks you through installing BI for SCCM from the Microsoft Marketplace, requesting a license, installing the Power BI Gateway, configuring database access, and connecting the semantic model. Once setup is done, you have a working set of dashboards built on the data ConfigMgr already collects.
  • Advanced Configuration is optional. Custom Inventory extensions (BitLocker, local admin groups, monitors, USB devices, warranty info, and more) unlock additional dashboards. The product works fine without these; dashboards that depend on them simply show no data until you enable the matching hardware inventory class in ConfigMgr.
  • Administration covers ongoing operations: semantic model parameters, backing up custom reports, creating a backup workspace, and performing in-place upgrades.
  • User Guides show you how to edit reports, repair broken visuals, build pop-up box visuals, and merge multiple datasets.
  • What’s New lists the changes in each release so you can track new features and fixes.

Pax is the PowerStacks assistant. Look for the Ask Pax button at the top of any article to get answers drawn from this documentation.