Setting up the dashboards
Once you have the .PBIX file, you can store it in any folder of your choosing and launch Power BI for Desktop by simply double-clicking on the file. Typically however, you will want to publish it so other users within your organization can have access to its reports via a web browser. This is however a topic beyond the scope of this guide. The following Microsoft documentation briefly covers how to do that:
Once Power BI for Desktop is running, you need to change the data sources defined in the .PBIX file so your own SCOM databases are being queried, rather than using the sample data that’s already embedded in the file, which comes from a Silect lab. In order to do this, click on Power BI for Desktop’s Edit Queries toolbar button, followed by Data source settings:
How do I get Power BI Desktop?
The most current version of Power BI for Desktop is always available at:
SCOM Dashboard Bundle Requirements
Note that two fundamental assumptions are being made by the reports contained in the .PBIX file you’ve received:
- The default Operations Manager database names (OperationsManager and OperationsManagerDW) have not been altered. In some cases, SQL queries defined in the .PBIX file rely on a USE [databasename] statement, which will fail if your Operations Manager database names have been changed from their defaults.
- Your Operations Manager database server itself is being monitored with one of Microsoft’s SQL Server Management Packs, such as “Microsoft.SQLServer.2016.Database”. This assumption is made so queries defined in the .PBIX file can, among other things, determine the name of the SQL server hosting the SCOM database itself.