This article explains how to establish a connection to BIM Track API in Power BI Desktop, which is the first step in setting up the BIM Track and Power BI integration.
Please note that this article only applies to the connection between BIM Track and Power BI Desktop.
This article contains the following sections:
Connect to BIM Track
- If not already done, download Microsoft Power BI Desktop.
- Open Power BI Desktop.
- From the Home ribbon menu, in the External data panel, click the Get Data drop-down and select More….
- In the Get Data dialog box, select Other, then Web, and then click Connect.
- In the From Web dialog box, select the Advanced option. To get all the hubs you have access to, complete the fields as follows:
- The first part of the URL in the URL parts section is the API base URL.
Do not add anything else after https://api.bimtrackapp.co - Add another part for /v3/hubs (Get all hubs). As you enter each part of the URL, the complete URL that will be used when you click OK is displayed in the URL preview box.
- In the HTTP request header parameters section, add the following key-value pair and replace <API_access_token> with your own API access token.
Always keep your access token private and communicate it only to legitimate stakeholders through secured channels.
- The first part of the URL in the URL parts section is the API base URL.
- Click OK.
- The Access Web content dialog box appears. Leave everything as default and click Connect.
After connecting, Power BI displays a list of your hubs.
Start working from an existing template
Need a headstart? Here’s a demo template you can use as a starting point for your reports.
To edit the template and/or update the access token, from the Home ribbon menu, in the External Data panel, click Edit Queries to launch the Power Query Editor. Then, select a query and open the Advanced Editor to make the desired changes.
You must apply your changes to each query in the template.