Aphex Help
Go to Aphex
  • Welcome
  • Getting Started
    • Joining your Team
      • Getting Around
      • Adding Tasks
      • Linking Tasks
      • Resources
      • Map & Location
      • Readying & Publishing Plans
    • Project Set Up
      • Importing
      • Folders & Structure
      • Users
      • Views
      • Resources & Assets
      • Map
      • Publishing & Routine
  • Guides
    • Imports
      • Importing your Master Schedule (XML)
      • Migrate existing plans to Aphex (CSV)
      • Importing Folders (CSV)
    • Feature Walkthroughs
      • Creating & Sharing Published Versions
      • Understanding Resources in the Plan
      • Exporting Data to a CSV
      • Copying tasks between Projects
      • Blockers
    • Integrations
      • ArcGIS Set Up Guide
      • Getting Started with Power BI Reporting
    • Reporting
      • Power BI Templates
  • Reference Docs
    • Fundamentals
      • Organisations
      • Projects
      • Tasks
      • Task Panel
      • User Preferences and Notifications
    • Scheduling
      • Views
      • Gantt
      • Board
      • List
      • Map and Clashes
      • Status and Progress Updates
    • Project Assets
      • Project Users and Teams
      • Resources and Assets
      • Structure
    • Publish, Print & Share
      • Printing
      • Published Versions and Shared Plans
      • Readying and Reviewing Plans
    • Data
      • Imports and Exports
      • Transferring
  • Frequently Asked
    • FAQs
      • How do I Add & Remove Filters?
      • How do I create & track Milestones?
      • How do I Move Folders?
      • How to login with SSO
      • Where have my Tasks gone?
      • How do I print my Plan?
      • Can I change the sort order of Tasks and Packages?
      • How is PPC calculated in the Power BI dashboard?
      • Why can't I delete a Task?
      • Why are the successors not scheduling?
      • How do I promise Tasks?
      • How do I delete multiple Tasks?
      • Why were some Tasks skipped from updating?
      • Why can't I upload an image for my Location?
      • How do I change the non-working days of a Task?
      • How do I make changes in bulk?
      • How do I transfer my work to another User?
      • How do I add new Users to the Project?
      • What can Lite users do?
      • How do I set a Reviewer?
      • How do I reset my Password?
      • How do I set up MFA?
      • Setting up SAML SSO
      • How can I use Aphex to update P6?
    • Troubleshooting
      • Troubleshooting Aphex
      • Troubleshooting your ArcGIS integrations
    • Coming Soon
      • 2025 Pricing Update
      • Changes to View Controls & Filters
      • Changes to the WBS
      • Changes with Status
  • Policies
    • Terms & 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
  • DEVELOPER
    • API & Integration
      • Plan APIs
        • Authentication
        • Project Assets
        • Tasks
      • Published Plans (Power BI) API
      • Work Area API
Powered by GitBook
On this page
  • Enable Integration
  • Connect from Power BI
  • Start from a Template
  • Connect to Aphex

Was this helpful?

  1. Guides
  2. Integrations

Getting Started with Power BI Reporting

Last updated 6 months ago

Was this helpful?

Things to know before you get started:

  • You will need the onto your device.

  • You must be a Project Admin to set up the integration.

  • The integration is unavailable for teams on the Starter Plan.

In addition to our built in reporting app, Aphex Insight we also provide an integration with Power BI so that teams can customise their reports and hunt for insight.

In this guide we will go through the key steps to start analysing your data in Power BI. Where necessary we will include links to more advanced features throughout.

Enable Integration

Enable in Source Project

The Power BI Integration is enabled at a project level so that every team has control over who can access their data. To start, head to your project in Aphex Planner and locate the Integrations page.

From here, enable the integration and take note of the unique Project API URL endpoint.

Generate a secret Token

In order to protect your data, the URL endpoint will not execute your request unless it also receives a valid Token.

Once the Integration is enabled, you are able to generate a secret Token. The token will only be displayed once, so be sure to copy it to your clipboard before moving on. If you do forgot your token or it expires, you can simply generate a new one.

With your URL and Secret Token in hand, we can head over to Power BI.

Start from a Template

If data models, Power Query and DAX are not your idea of a good time, then you will want to start by downloading a pre-made Power BI Template file. These are made by the team at AphexHQ or the Aphex Community and allow you to simply connect your data and go.

Connect to Aphex

Once your template is opened in Power BI, the application will ask you to input the following:

  • Project API URL

  • Token

  • Project Name

Note: if you receive a warning about installing the latest version of Power BI Desktop you can most likely continue on without issue (although updating your software is usually a good idea!)

Next, paste in the values we secured in the previous step and select "Load". Power BI will securely request your project data and load it into the report. Now that your report is loaded you are free to customise it to suit your project.

Connect from Power BI

If you do prefer to build you own you report from scratch, then you will probably want to jump over to the doc which covers Authentication and Data Models in more detail.

Got a great report template? Why not give back to the Aphex Community and share it with us

Power BI API reference
[email protected]
Desktop Power BI application downloaded

Download a Power BI Template