You are here

Using Microsoft Power BI with Aconex Cost

Use MS Power BI to produce interactive reports and dashboards.

Setting up Power BI

MS Power BI can be used to produce interactive reports and dashboards, accessing live data from Aconex Cost using the APIs. To learn how to setup and access Cost APIs, see Accessing Cost Data with APIs.

These instructions will help you connect Power BI to Aconex Cost data, you can then connect additional data by repeating these instructions with different API end points.

  1. Create a new or open an existing Power BI file.
  2. Click the New Source drop down menu and select Web.
The New Source drop down menu.
  1. In From Web, select Advanced.
  2. Enter the URL for the API end point you want to use. Note: The URL contains Organization and Project fields which can be converted to parameters in Power BI.
  3. Add the Token created previously as a HTTP request header parameter.
Adding a token.
  1. Click Ok. If the URL and Token are correct, you will see the Power Query Editor showing a data file.
  2. Use the Open As button, and select JSON.
Selecting the Open As button.
  1. The data will display in a table with Body and Error rows.
  2. Click List (in the Body row), to expand the returned data. This opens a list of records. 
  3. Click the To Table button, then click OK in the popup window.
An example of the records list.
  1. In the table window, click the Expand Record button next to the Column1 heading.
  2. Click Ok.
The OK button.
  1. The query will now show data from Cost which can be used to create Power BI reports and dashboards.
  2. Repeat these steps to connect different API endpoints.

Was this article helpful?

Thanks. A ticket has been opened with the Support Central team.