Power BI

By connecting Aphex to Power BI, you can use your weekly Published Plans to create consistent, reliable dashboards without adding extra steps. The data’s already there, this is just a way to make use of it.

This page pulls together everything you need to get set up, along with links to downloadable reporting templates and supporting docs.

Connecting Aphex to Power BI

Each project can generate its own secure connection to Power BI, giving teams full control over whether and when to enable reporting.

You can enable the Power BI data source from the project’s Integrations menu, then generate a token and URL to connect to Power BI.

Set Up Guide

About the API & Data Model

The Power BI API is based entirely on Published Versions, meaning your reports are built from official, reviewed snapshots of the plan. Because these versions are already created as part of your planning cycle, there’s no extra work required.

You get access to everything: task details, PPC, variance, subcontractor activity, who’s made ready, delays & even milestone movement.

Because it’s versioned data, it’s easy to track changes over time.

Published Plan API

Free Power BI Templates

To help you get started quickly, we’ve created a set of plug-and-play Power BI templates. These dashboards work with your weekly Published Pan data and cover common use cases like PPC tracking, delay trends, and subcontractor performance.

Once you’ve connected your project, you can also schedule a refresh so the dashboards pull in each week’s data automatically after a new version is published. Most teams choose to align this with their weekly planning cycle.

Templates are free to download and easy to customise.

Resource Hub How the Project Reporting Suite works