Embedding Power BI Reports

AIM-A has the capability of creating reports based on data processed by the gateways. For example, a conformance issue report, completeness of the information report or consistency on data report.

Note: You must first whitelist the customer's domain with AVEVA CDO before providing them with access rights to BI Gateway.

Data loaded through the AVEVA Data Pipeline is loaded into:

• AIM-A database

• Reporting Database

The Business Intelligence Gateway cloud service hosts the SQL Reporting Database which can be used to generate Microsoft Power BI reports. This database is fed by the Registers Gateway with data requirements such as, source system, historical database, etc. Clients must have their own Power BI platform / service (for example, ssrs / powerbi, etc).

Note: Accessible from on-prem client (client IP white-listing required for access).

Before configuring any reports, administrators need to ensure that the Business Intelligence Gateway cloud service is available on CONNECT. Refer to the section on Reporting for further details.

We also need to enable the Reports icon in the AIM-A dashboard. Use the AIM-A Settings dialog (administrator role required), and for each role, go to the Global Navigation tab and select Show the Reports link.

Register configuration

Use the Registers Gateway to create the report objects to store the link and then GDP to upload them and create associations between Report Document and Report File register.

ISM configuration

In case, you have raised a request for enabling the Business Intelligence Gateway cloud service, then you will also need to request that the AVEVA Cloud DevOps team add the Power BI workspace URL (app.powerbi.com ) as portal safe domain/white list.

Any info locator attribute (which has a URL ) needs to be whitelisted/ included in safe domain.

PrimaryLink attribute displays the Power BI report link in the UI and InfoLocator takes us to the actual Power BI report link. You must ensure that the attribute IDs matches with the InfoType and InfoLocator exactly as provided in the sample.

Input files

Feed the Registers Gateway with the information required for your info_locators and links to your Power BI reports. Once this is processed, it will appear under the Reports menu in AIM-A dashboard.