Integrate BI Gateway with AIM-A for Reporting

This section describes the configuration needed to run Power BI reports on the data loaded into AIM Advanced. Data loaded through the AVEVA Data Pipeline is loaded into an AIM database and a Reporting database. The Business Intelligence Gateway cloud service uses the Reporting database to generate Microsoft Power BI reports.

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

Creating a Tenant

1. Sign into CONNECT and choose an account.

2. Select the hamburger icon (), then select Folder Management.

3. Select Add Folder, then fill in the required details. A new tenant is created.

4. To enable the tenant service, select the toggle button to switch it On.

   Wait for about 10 minutes as the database gets created.

   

Assigning Groups and roles

5. Once the database is created, select the vertical ellipsis icon ( ) , and select Manage roles.

6. Under the Groups tab, select Assign group.

7. Create the required groups. You require at least an Admin group and a Reporting Database group.

8. For each group, add the following:

   1. Group name

   2. Group description

   3. Users

   Note: The only special character allowed is an underscore ‘_’.

   If you are being added to the Active Directory for AVEVA Intelligence in the cloud, for the first time, accept the invite you receive via email. However, if you are already registered in the Active Directory, you may not receive an email. Follow the instructions:

   1. Visit https://portal.azure.com/d9bde4ea-8859-4e11-9efa-491b97c4db44 in an incognito mode tab.

   2. Log in with your credentials.

   3. Accept the invite.

9. Under the Roles tab, select Assign role. It is compulsory to add the following roles:

   4. Administrator role – Only users/groups with the Administrator role can view the tenant model builder.

   5. Reporting - Analytics User role – Only users/groups with the Reporting - Analytics User role can view the reporting database information and later configure a database.

Important: 1:1 mapping is only allowed within the same account. A BI Gateway role can be assigned to only one group and one tenant. The tables below demonstrate the 1:1 mapping within two accounts:

Configuring the Database

10. Return to the Home page () from the task list and go to the tenant.

    Note: Only the user(s) with the Admin role can access the tenant model builder.

    

11. For Power BI users to access the reporting database, under the profile icon, select Whitelist Client IP.

    

12. Add a new Firewall rule by pressing the + icon.

    You can add your own IP address for Start IP and End IP.

    

13. Under the profile icon, select View Datastore Information. You can copy the reporting database name and the reporting database service name from here.

    

14. Go to the program you use to configure databases. For example: Power BI, SQL Server Management Studio, etc.

15. Fill in the required information to connect to the server.

Further Reading

For general information on the BI Gateway, refer to the AVEVA BI Gateway Documentation.

For information on how to configure a private endpoint for your data and integrate it with the AVEVA BI Gateway, refer to Private Endpoint Configuration.