Enterprise 11 Example: Retrieve information in Power BI using business information API

The Power BI connector enables you to access the Bot Insight API from Power BI. This example task show you how retrieve information from the Bot Insight API and build data visualizations in Power BI.

Procedure

  1. Open Power BI.
  2. Open the Navigator window, and enter the Control Room credentials to log in and access the Automation Anywhere Control Room.
  3. In the Display Options menu, select fx Business Information.
    The API window appears.
  4. In the botName field, enter the name of the bot, or the task for which you want to visualize the analytical data.
  5. In the chunk field, enter the offset value for the rows or records that you want to retrieve.
    • If chunk = 0, and limit =1000, then rows 0 -1000 will be retrieved.
    • If chunk = 1, and limit =1000, then rows 1001 -2000 will be retrieved.
  6. In the fromDate field, enter the date from when you want to retrieve the information.
    Format: yyyy-mm-dd, or yyyy-mm-ddTh:m:s.msz (2020-02-20T12:45:23.000z)
  7. In the toDate field, enter the date till when you want to retrieve the information.
    Format: yyyy-mm-dd, or yyyy-mm-ddTh:m:s.msz (2020-03-21T15:45:32.000z)
    Note: The toDate is optional. If you do not enter any information, the current date will be assumed as the toDate.
  8. In the limit text field, enter the number of rows or records you want to retrieve.
  9. Click Apply.
    Power BI displays the data visualization.