Configure Power BI connector

Configure the data connector in Power BI to retrieve information from the Bot Insight API to enable data analytics.

Prerequisites

Ensure that you have the Bot Insight Admin, or AAE_Admin role assigned to you in the Control Room.

Note: A

Bot
                        Creator

license is required to generate a default dashboard with tasklogdata for Power BI.

Note: The Power BI Connector is supported with Database Authenticated Control Room and Active Directory authentication.

Procedure

Log in to the Power BI.
Click Get Data.
The list of all the Power BI certified connectors appears.
- For information about how to access non-certified custom connectors, see Connector extensibility in Power BI.
- When you update the dataset of two or more datasets, you might observe the Authentication 500 Internal server error. For resolving this error, see Automation 360 | Authentication 500 Internal server error while refreshing in power BI (A-People login required).
Select Automation Anywhere and click Connect.
In the Automation Anywhere - Login window, enter the following information:
1. In the Control Room Version drop-down menu, select the version of the Control Room.
2. In the Control Room Host field, enter the IP address or the host name of the Control Room server.
3. In the Bot Insight Host field, enter the IP address or host name of the Bot Insight server.
Click OK.
In the Automation Anywhere Login window, enter your Bot Insight user name and password.

To provide the credentials for Active Directory authentication, you must enter the domain name delimited by a double backslash (\\) along with the user name in the User name field. For example: domain name\\user name.
Click Connect.
The Bot Insight APIs are authenticated and the authorization tokens are generated. The Bot Insight APIs are loaded dynamically from Swagger, along with the applicable request parameters.
Select the required Bot Insight API from the Navigator menu and enter the information in the respective fields.
Click Load.
The API retrieves specific information from the server.
To learn how to retrieve information from Bot Insight APIs in Power BI, see Bot Insight API .
Click Transform Data to convert the structured JSON response to a visual data model.

Automation 360

Configure Power BI connector