Guide to setting up ActivityInfo and Power BI

Users can link ActivityInfo to Power BI through the API. In this short guide we will explain how you can setup the basis, so the data from ActivityInfo goes directly to Power BI.

First of all you need to open Power BI, if you don't have it installed then you can download here and create an account.

Once the download is completed, you will need to sign into your Power BI account.

Power BI is a product provided by the Microsoft Corporation for which we do not provide support. Please consult the Power BI website at to learn more about how to use the product.

Obtain the URL of your form from the Design Tab

Before you connect Power BI to your form in ActivityInfo, you will need to obtain the URL of the API endpoint for your form.

Find the form identifier in the Design Tab

  • For forms, you will find the identifier when you select the form in the Design tab. The identifier is shown in the ID field.

Find the form identifier in the Table View

  • For forms, you will fine the identifier when you open the form in Table View. The identifier is shown in the URL.
Construct the URL to your form

The URL of the API endpoint for forms in ActivityInfo looks like{REF}/query/rows where {REF} should be replaced with a reference to your form. 

Another example: if you are targeting a form 99, then your url will look like this:

[REF] has to have 10 digits  after the 'a'. 

Connect ActivityInfo and Power BI

To connect ActivityInfo to Power BI, log into Power BI and follow these steps:

  • Click "Get Data" and select "Web",
  • In the dialog window, select the "Basic" option and enter the URL for the API endpoint for your form (see below) and click "OK",
  • A new dialog window with title "Access Web content" appears: select "Basic", enter your ActivityInfo login credentials and click "Connect".
Convert list to table format
  • After you have connected your form to Power BI, the Query Editor will open and display a "List" as the result. The following steps explain how to convert this list to a table.

Convert list result to table

  • Click "To Table", a pop-up will appear inviting the user to select or enter delimiters and how to handle extra columns.
  • Accept the default settings by clicking "OK".

Select Columns

  • Untick the "Use the original column name as prefix"
  • Click "OK"

Make final structural changes to the table

  • You can make further changes to your table as shown below. For example, re-order the columns, remove columns, re-name the columns etc.