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

  1. Log in to the Power BI.
  2. Click Get Data.
    The list of all the Power BI certified connectors appears.
  3. Select Automation Anywhere and click Connect.
  4. 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.
  5. Click OK.
  6. 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.

  7. 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.
  8. Select the required Bot Insight API from the Navigator menu and enter the information in the respective fields.
  9. 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 .

  10. Click Transform Data to convert the structured JSON response to a visual data model.