Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Configure Power BI connector

  • Updated: 6/03/2021
    • Automation 360 v.x
    • Optimize
    • RPA Workspace

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 your user name is registered in the Control Room and that you have the Bot Insight Admin, AAE_Admin, or the Bot Insight COE Admin role assigned to you.

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.

    For information about how to access non-certified custom connectors, see Connector extensibility in Power BI.

  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.
Send Feedback