LogoLogo
Trust CentreRoadmapStatusLogin
  • How can we help?
  • Planner
    • Getting Started
    • Features
      • Gantt
      • Board
      • List
      • Map
      • Tasks
      • Blockers
      • Calendars
      • Clashes & Work Area
      • Exports
      • Folders
      • Labour & Plant
      • Locations
      • Master Schedule Import
      • Materials
      • Milestones
      • Owner, Assignee & Teams
      • Packages
      • Printing
      • Progress Updates
      • Publishing
      • Readying & Reviewing
      • Relationship Links
      • Shift
      • Spreadsheet Import
      • Status
      • Subcontractor
      • Tags
  • Integrations & API
    • Power BI
      • Connect Aphex to Power BI
      • How the Project Reporting Suite works
      • How is PPC calculated?
    • Master Schedules
      • Asta Powerproject
    • External Map Layers
      • Connect ArcGIS Layers
    • APIs
      • Published Plans API
      • Work Area API
      • Plan APIs
        • Authentication
        • Project Assets
        • Tasks
  • Organisations & Projects
    • Organisation Users
    • Project Users
    • Project Settings
  • Account & Task Properties
    • User Preferences and Notifications
    • Task Properties
  • Troubleshooting
    • Troubleshooting Aphex
    • Troubleshooting your ArcGIS integrations
    • Troubleshooting Microsoft Teams External Access
    • Troubleshooting Your SAML Single Sign-On Setup
  • Authentication
    • How to login with SSO
    • How do I set up MFA?
    • Setting up SAML SSO
    • How do I reset my Password?
  • Policies
    • Compliance and Certification
    • Terms & Agreements
      • Terms of Service Overview
      • Terms of Service
      • Subprocessors List
      • Service Level Agreement
    • Policies
      • Acceptable Use Policy
      • Privacy Policy
      • Cookie Policy
      • Fair Billing Policy
      • Support Policy
    • How Aphex Uses AI
Powered by GitBook
On this page
  1. Integrations & API

Power BI

Last updated 21 days ago

Was this helpful?

CtrlK

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