Copy files locally
The NHVR PowerBI template contains an Excel file and a PowerBI template file. Copy both to a local folder on your machine.
Open PowerBI template
Open the PowerBi template file and the following setup screen will appear. The example below is for Department of Transport - Victoria.
Subscription key
In the SubscriptionKey field enter the subscription key of the API user setup for your organisation account/s.
If you have a separate accounts for your In principle approvals you will need to ensure the API user is setup for both accounts.
Path to Excel
Copy the full path to the Excel file using windows explorer. Click on the excel file and click on the 'Copy path' toolbar option. Alternatively you can type out the path e.g.
C:\powerbi\PartnerConsent-Vic.xlsx
Paste or enter the path into the PathToExcel field as per the example below
Load
Click load and the following screen will appear.
Privacy levels
If the privacy level dialog appears then set as private or organisational and click save.
Usage
After the report data has refreshed the PowerBI report is ready for use.