Create reports on Power BI

  • Article

This article describes how to create reports on Power BI for Azure Monitor SCOM Managed Instance.

Prerequisites

  • Azure Active Directory based authentication:

    1. Create an Azure Active Directory group for the users to whom you want to provide permissions to read data from the SQL Managed Instance through this Power BI report.

    2. Create login credentials for the Azure Active Directory group in the SQL Managed Instance, which adds the user principal of the group in the SQL Managed Instance. To create a login, see Create Login (Transact-SQL). Screenshot showing create login option.

    3. Provide db_datareader permission to the Login on Data warehouse database. Screenshot showing login properties.

    4. Download the supported SSMS and add login to SSMS.

    5. In the network security group of the subnet where the Azure SQL Managed Instance is hosted, create an NSG rule to allow public endpoint traffic on port number 3342. For more information about how to configure public endpoint, see Configure public endpoint. Screenshot showing destination port range.

  • SQL based authentication:

    • You need the username and password of the SQL Managed Instance.

Create reports through public endpoint of SQL MI

  1. Sign in to the Azure portal and search for SCOM Managed Instance.

  2. On the Overview page, under Reports, select Power BI. You have three options on the Power BI page.

    1. Prerequisite: Allows you to manage endpoints.
    2. Configure and install Power BI: Allows you to install and configure the SCOM Managed Instance dashboard in Power BI.
    3. View Power BI dashboard: Allows you to visualize the SCOM Managed Instance dashboard in Power BI after the configuration.

  3. Review the Prerequisites to ensure Public endpoint of SQL MI is enabled. You'll notice the Database Host URL and Database name are displayed. Screenshot showing public endpoints.

  4. Select Configure Dashboard, Powerbi.com opens in a new browser. Select Get it now to install Microsoft SCOM managed instance reports Power BI app in your workspace. Screenshot showing Power BI app.

  5. The app displays sample data. You can edit the parameter values Data-Warehouse DB host URL and Data-Warehouse Name.

    Note

    To update the parameters, go to Settings of the dataset, and edit the parameters or select Connect your data in the banner. Screenshot showing Connect your data option.

  6. After you enter the parameters, select any one of the following authentication methods:

    • SQL username and password-based method
    • Azure Active Directory-based method

    The dataset and reports will be refreshed.

    Note

    To view Power BI reports of multiple SCOM Managed Instances, Microsoft SCOM managed instance reports app must be installed individually in a different Power BI workspace.

Next steps

Connect the Azure Monitor SCOM Managed Instance to Ops console.