Update PowerBI Connector

The TeamAssurance Support team occasionally request you to update the PowerBI Connector to make use of the latest improvements. They will provide two json files (Update-Tables.json, Update-Workflow-Logic-Apps.json).

A. Run file Update-Tables.json

1. In Azure, select the relevant Resource Group

2. Deploy a custom template

   

3. Click on Build your own template in the editor

   

4. Select json file “3. Update-Tables.json” 
5. Click “Review + create” then click “Create”. Wait for the deployment to complete.

B. Run file Update-Workflow-Logic-Apps.json

1. Deploy a custom template, this time select “4. Update-Workflow-Logic-Apps.json”
2. Click “Review + create” then click “Create”. Wait for the deployment to complete.

Note: If you have previously run Step C it does not need to be repeated and can be skipped. 

C. Grant Logic App ta-import-site access to Key Vault

If ta-import-site has never been granted access to the Key Vault, run this step. You'll only need to do this once (ever).

1. Open the ta-import-site Logic app

2. Click “Identity” and copy the Object (principal) ID

   

3. Open the Key Vault.

4. Select Access Policies. Click Create. 

   

5. In Permissions, under “Secret permissions”, select “Get” and “List” and click “Next” 

   

6. In Principal, paste the Object ID from #2 in the search box and select the identity that pops up. Click “Next”.
7. In Application (optional), click “Next”.
8. In “Review + create”, click “Create” 

D. Test

1. Open the Logic App named ta-import

2. Select Run > Run.

   

3. The import will start, and depending on the amount of data already created in TeamAssurance, can take a minute or an hour or more
4. You can click Refresh (see above image) to see where the import is up to
5. Assuming it works, then the next import will occur overnight