Přeskočit na hlavní obsah

Setting up Power BI reports

Setting up reports for ALVAO SaaS​

Technical requirements​

  • Power BI Pro or Premium subscription

Procedure​

  1. Power BI reports fetch data from Alvao using your personal Entra ID account. Add your account to the Report readers group to enable Power BI to read data from Alvao using your account.

    Power BI has access to all data in Alvao that are accessible to you. To enable Power BI to access object data, add your account to the Asset Management readers group. For more details, see object security and object property security. To enable Power BI to access ticket data, grant yourself at least Reader service team role in all services you want to report.

  2. Go to the ALVAO ITSM Analysis and click Get it now.

  3. After installing the app into your Power BI workspace, open it and click on Connect your data.

  4. In the Connect to ALVAO form, keep the value https://reports.alvao.com in the Alvao Reporting Service endpoint field.

    In the HistoryMonths parameter, optionally change the length of the ticket log history in months to be loaded into the report. Older records are not loaded into the report. The larger the value you specify, the longer it will take to update the dataset and the larger the size of the dataset.

    Click Next.

  5. Set:

    • Authentication method to OAuth2;
    • Privacy level to Organizational.
  6. Click Sign in and connect, and wait for the data to be fetched.

Setting up reports for on-premises Alvao​

This section explains how to set up reports using an application account in Alvao which is simpler than Entra ID. If you prefer using more secure Entra ID authentication, follow Setting up reports for on-premises Alvao with Entra ID.

Technical requirements​

  • Power BI Pro or Premium subscription
  • Alvao REST API accessible from the Internet

Procedure​

For an on-premises Alvao, the setup procedure is similar to the ALVAO SaaS procedure above with the following exceptions:

  • Instead of your personal Entra ID account we will use a dedicated application account in Alvao.

    Create such an account in Admin - Users - New user:

    • First name and surname - e.g., Power BI reports
    • User name - e.g., powerbi
    • Extended - Application account - checked
      • Other applications - checked

    Set an account password using the Change password command.

  • In the Connect to ALVAO form, enter the public URL of your Alvao REST API in the Alvao Reporting Service endpoint field, e.g., https://alvao.contoso.com/AlvaoRestApi.

  • Use the Basic authentication method with the credentials of the application account you have created above.

In case of trouble connecting the report to your REST API, check the availability of AlvaoRestApi from Power BI servers and check your firewall and proxy settings.

Sharing reports​

Share the report with other users who have a Power BI Pro license or higher. As the report uses row-level security, each individual user will see only data they are eligible to view according to their security settings in Alvao.

Customizing reports​

You can customize the report by modifying and adding new visuals. You can also create new custom reports based on the dataset created from the report template. This way, the datasets will be shared and will only be updated once for a given report.

Displaying custom fields​

You can add custom fields to the report with these steps:

  1. Open the report in the Power BI Desktop application.
  2. On the Home tab, use the Transform data command.
  3. In the Queries panel, select the query you want to include custom fields in:
    EntityQuery name
    ObjectObjectEnu
    Object relationN/A
    OrganizationOrganizationEnu
    PersonPersonEnu
    Software licenseN/A
    Software productN/A
    ServiceSectionEnu
    SLASlaEnu
    Ticket statusRequestStateEnu
    TicketsRequest2Enu
  4. In the table preview, expand the More columns column and select required custom fields.
  5. Click Close & Apply in the ribbon.

Incremental refresh​

Incremental refresh is a feature that allows you to refresh the dataset in Power BI Service only with new data which improves model refresh performance. Currently it is enabled only on the ticket log data source (Query RequestLogRecordEnu).

If an error or downtime prevents the refresh from occurring within the set interval for incremental refresh (default is 14 days), the subsequent successful load will not capture the missing data. In this case, it is advisable to republish the report to the Power BI service.

Viewing reports in Power BI Desktop (free)​

You can also view ALVAO reports in the Power BI Desktop free application.

  1. Install the Power BI Desktop app on your computer.
  2. Download the AlvaoAnalysis.zip file, unzip it, and open the resulting AlvaoAnalysis.pbix file in the Power BI Desktop app.
  3. To connect to an on-premises Alvao, go to the Home tab, click the Transform data - Edit parameters, and enter URL of your Alvao REST API in the Alvao Reporting Service endpoint parameter, e.g., https://alvao.contoso.com/AlvaoRestApi. If you refresh report data only from your company's local network, the URL does not need to be publicly accessible from the Internet.
  4. Use the Refresh - Schema and data command. In the OData feed form, specify the authentication method as described in the Setting up reports for ALVAO SaaS / on-premises Alvao sections above. For Entra ID authentication, use the Organizational account tab. For application account, use the Basic tab.
  5. Wait for the data to be loaded into the report.