Skip Navigation LinksALVAO 11.2Asset manager guideSearching, reporting and data analysisPower BI report templates Skip Navigation Links.


Change Alvao version
Change language
Skip Navigation LinksALVAO 11.2 / Asset manager guide / Searching, reporting and data analysis / Power BI report templates

Power BI report templates

The Microsoft Power BI report templates are ready-to-use reports that you can use immediately or customize to create your own reports to suit your needs.

We recommend using the Power BI service included with paid subscriptions to Power BI Pro and above. This service allows, among other things, to update the dataset of reports regularly, e.g. once a day during the night hours, when a slight slowdown of applications due to data updates affects only a minimum of users. The display of the reports itself no longer slows down the response of the applications, because only the data from the updated dataset is used.

For more information on Power BI, tutorials and courses, please see the Power BI documentation.

Note:
Alternatively, you can also view the reports in the free Power BI Desktop application. In order to ensure that updating the dataset during normal business hours does not slow down the response of Alvao applications, we recommend using analytic database to update the dataset.

Installation

  1. Download the report template from ALVAO Download.
  2. Install the application:
  3. View the contents of the report based on the prepared model data.
  4. Connect the assembly to your REST API:
    1. On the Home tab, expand the Transform Data command and use Edit parameters.
      • Enter your REST API url.
      • HistoryMonths - 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.
    3. After loading the OData feed window will appear. Select the Basic tab (on the right) and enter User name and Password to connect to the REST API.
      The user account used must be Application account - Other applications.
      Only information that the used Alvao account has access to is read from the database into the dataset, see:
      • Asset Management - permissions to read objects and property-values;
      • Service Desk - permissions to view tickets, i.e. the role Reader in the given services;
      • Service Desk - permissions to read information about people and organizations, i.e. membership in the group Contact readers or Contact administrators.
    4. Save OData feed dialog.
  5. Refresh report and wait for the data to be loaded into the report.
  6. Upload the report to a workspace in Power BI Service using the Publish command.
  7. In the dataset settings, turn on regular updates every day at night.
  8. Click on a report to view that report.
Tip:
You can customize the range of the displayed data by using the filters, which can always be found at the right edge of the report.
Tip:
Share the report with other users who have a Power BI Pro license or higher.
Tip:
You can create your own reports based on the datasets created from the report templates in Power BI service. This way, the datasets will be shared and will only be updated once for a given report.

Displaying ticket custom fields

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

  1. On the Home tab, use the Transfrom data command.
  2. In the Queries column, open the Request2Enu Query.
  3. Enter the required custom fields to the right place (highlighted in the image) in the query.

Alvao Analysis

This report contains a set of pages with basic overviews of services, tickets and facilities in Alvao.

The template for this report is stored in the file AlvaoAnalysis.pbix.

The first pages of the report relate to the ALVAO Service Desk product. These are followed by pages for ALVAO Asset Management:

  • Tickets on objects - at the top of the page you can see the objects in the graph that have the highest number of tickets linked to them in ALVAO Service Desk. Select an object in the graph and the corresponding tickets will be displayed at the bottom.
  • Objects - at the top of the page, you can see the number of objects by manufacturer, object type and device model in the graphs. Select a value with the mouse and details of the corresponding objects are displayed at the bottom of the page.
  • Computers - at the top of the page, you can see the number of computers by manufacturer, type of computer (e.g. desktop, laptop, ...) and operating system in graphs. Select a value with the mouse and the bottom of the page shows details of the corresponding computers.
  • Object age - at the top of the page, you can see a graph showing the number of objects by their age in years, with a color breakdown by object type. Select any value in the chart and the corresponding objects will be displayed at the bottom of the page.
  • Installed software - at the top of the page you can see the numbers of software installed on computers in graphs by publisher and product. Select a value and at the bottom of the page you will see details of the computer on which the software is installed.

Each user in the report can only see the objects and tickets that they are allowed to see in Alvao.

The assembly is available in English only.

 

Did not find what you were looking for? Ask our technical support team.