Power BI connector: Add a New Site

Prerequisite: The PowerBI Connector is already setup with at least one site


This is for Customers that have multiple Sites.


  1. Open the Key Vault in Azure
  2. Select Secrets. Click Generate/Import
  3. Fill in the following values:

    1. Name - input the TeamAssurance Site Code

      This is usually three-characters and are used to identify the TeamAssurance Site. If you are unsure, go to any Activity in the TeamAssurance site you are connecting, click on the three dots menu (top right) and Copy Link.

Now paste that somewhere. You will see the Site Code in the position highlighted below.

b. Secret value - API key


  1. Click "Create"
  2. Open the Import Workflow Logic app
  3. Click "Logic app deisgner"
  4. Expand "Init siteCode var to sites to run"
  5. Add the Site Code/ID to the array
  6. Click "save"

That completes the Site set-up. To ensure any historical data is pulled through in the next import, the LastRun date must be cleared.


Clear LastRun date

This deletes the reference date for how far back the import will look to pull data.


  1. In Azure, navigate to the Storage Browser (or simply type Storage Browser in the Search bar)


  1. Select the relevant storage account

  2. Select Tables > LastRun

  3. Check all the boxes for each LastRun, then Delete

  4. Confirm the Delete

The next scheduled run will now pick up the new Site including any historical data.