Project reporting, it’s something that we all love to do, there’s nothing better than crafting a report featuring a wide spectrum of colours (except red). Well today I have some exciting news!

Literally a couple of weeks ago I wrote an article concerning the Project Online roadmap within which I announced that Microsoft would be releasing a Power BI content pack for PPM – well it’s now here!

So for existing users of Project Online with access to Power BI, here are some instructions on getting it up and running.

1. Within Power BI, click on the ‘+’ next to Datasets

Power BI2. Click on ‘Get’ within the ‘Services’ boxGet Data

3. Select the ‘Microsoft Project Online’ dataset and choose ‘connect’

Microsoft Dynamics

After clicking on ‘connect’ you’ll be asked to enter the Project Web App URL and select the appropriate authentication method and sign in.

Once you’ve successfully signed in, you’ll see in the left hand menu that ‘Microsoft Project’ is listed under Dashboards / Reports:

Microsoft Project Online

 

After clicking on ‘connect’ you’ll be asked to enter the Project Web App URL and select the appropriate authentication method and sign in.

Once you’ve successfully signed in, you’ll see in the left hand menu that ‘Microsoft Project’ is listed under Dashboards / Reports:

Reports

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I’ve included some example screenshots showcasing some of the Dashboards and Reports:

Dashboards

Users can drill down by simply clicking in to any or the dashboard elements, below you see a drill down of ‘Active Risks’:

Dashboard

 

Power BI also allows users to see data by simply asking the right questions:Power BI 2

Within Reports users also have access to a wide range of filters and visualisation options:

Dashboard 2

So if you’re an existing user of Project Online and Power BI and you haven’t already accessed the PPM content pack, what are you waiting for?

For those of you who would like to test drive Project Online and Power BI,  contact us today to discuss!