The data warehouse role on SCCM comes with a set of Reporting Services reports which are very slow to load and quite painful to use.

 

This Power BI template tries to reproduce each reports that are embeded with the data warehouse but with the flexibility of Power BI, meaning that once the data are loaded, it's quick to launch, filtering is easy and you'll even be able to author your own visuals without having to deep dive in report builder.

 

 

 

The Power BI files contains one tab per report that comes with SCCM.

 

To use this you'll need :

 

Open the file then fill in the prompt the name of the SQL server hosting the DW database and the name of the DW database (not the operationnal database the data warehouse one !). 

 

Note: This template is a base of work, feel free to adapt it to your needs.