Data connector for Power BI

The data connector for Power BI enables you to establish a secure connection to Power BI, and generate and visualize data analytics. You can connect to the Bot Insight APIs in Power BI and apply specific parameters for each of the APIs.

The connector transforms the Bot Insight API responses to data visualizations in Power BI. The data connector for Power BI enables you to perform the following functions in Power BI:
  • Authenticate and connect to the Control Room.
  • Connect to APIs.
  • Generate API responses.
  • Transform the API responses to create a data model.
  • Create visuals, charts or graphs, to represent the data.
  • Create reports.
  • Share reports with other users on Power BI.
You can access the following APIs from Power BI:
  • getaudittrialdata
  • getbotrundata
  • gettaskvariableprofile
  • gettasklogdata
Note: Automation Anywhere Power BI connector is certified and available as part of the Microsoft Power BI Desktop August release. The connector is available in the Other section of the Get Data dialog box in Power BI.

To update your Power BI to the latest certified release version and use the connector plug-in, manually deploy the data connector in Power BI. This enables you to retrieve information from the Bot Insight API for data analytics.

Trouble: When you attempt to refresh the data in a Microsoft Excel worksheet, an authentication error can occur from multiple simultaneous attempts through open windows and tabs. To avoid this error, perform the following steps:
  1. In the Power BI desktop application, navigate to File > Options and settings > Options.
  2. From the Current File section, select Data Load.
    Note: Do not select Data Load from the Global section.
  3. Disable the check box for Enable parallel loading of tables.