Setting up Power BI reports
Setting up reports for ALVAO SaaS
Technical requirements
- Power BI Pro or Premium subscription
Procedure
-
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
Readerservice team role in all services you want to report. -
Go to the ALVAO ITSM Analysis and click Get it now.
-
After installing the app into your Power BI workspace, open it and click on Connect your data.
-
In the Connect to ALVAO form, keep the value
https://reports.alvao.comin 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.
-
Set:
- Authentication method to
OAuth2; - Privacy level to
Organizational.
- Authentication method to
-
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.
- First name and surname - e.g.,
-
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
Basicauthentication 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:
- Open the report in the Power BI Desktop application.
- On the Home tab, use the Transform data command.
- In the Queries panel, select the query you want to include custom fields in:
Entity Query name Object ObjectEnu Object relation N/A Organization OrganizationEnu Person PersonEnu Software license N/A Software product N/A Service SectionEnu SLA SlaEnu Ticket status RequestStateEnu Tickets Request2Enu - In the table preview, expand the More columns column and select required custom fields.
- 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.
- Install the Power BI Desktop app on your computer.
- Download the AlvaoAnalysis.zip file, unzip it, and open the resulting AlvaoAnalysis.pbix file in the Power BI Desktop app.
- 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. - 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.
- Wait for the data to be loaded into the report.