#ProjectOnline #PPM #PowerBI Report Pack v2 #BI #Reporting #PowerQuery #DAX #Office365

Back in January this year I published my first Power BI report pack for Project Online, the post can be found here: https://pwmather.wordpress.com/2017/01/03/projectonline-ppm-powerbi-report-pack-bi-reporting-powerquery-dax-office365/ I have now published the second version of my report pack for Project Online. This version can be download from the link below:

https://github.com/pwmather/ProjectOnline_PowerBI_Templates/blob/main/PWMatherProjectOnlinePowerBIReportPackv2.pbit

This report pack consists of 8 reports for Project Online, these reports can be seen below:

Portfolio Report page:

Issues Report page:

Risks Report page:

Project Report page:

Resource Demand Report page:

Resource Report page:

Timesheet Summary Report page:

Timesheet Detail Report page:

These reports only use default intrinsic fields so it should work for all Project Online deployments.

Once downloaded, the report pack data sources will need to be updated to point to your target Project Online PWA instance. To do this you will need the Power BI desktop tool which is a free download here: https://powerbi.microsoft.com/en-us/desktop

Open the downloaded PWMatherProjectOnlinePowerBIReportPackv2.pbit template file in Power BI Desktop and follow the steps below to point the data sources to your Project Online PWA instance:

• In the parameter window that opens, enter the full Project Online PWA URL
• Click Load
• The data will now start to load and you will be prompted to connect
• On the OData feed window, click Organizational account and click Sign in and enter credentials as required
• Click Connect
• On the Privacy levels window set the privacy as required
• Click Save
• The data will load – this may take a few minutes depending on the dataset size in Project Online
• Access the Project Report page and select a project from the project filter
• Save the report

This file can either be emailed around to colleagues with details on how to update the credentials to their own or what would be better is to publish the report to your Power BI workspace can create an organisational content pack that others can add to their Power BI workspace. If the Power BI organisational content pack is the chosen option, you might want to create a Dashboard first. See a previous blog post on this: https://pwmather.wordpress.com/2017/02/10/projectonline-ppm-powerbi-report-pack-publish-bi-reporting-powerquery-dax-office365/

Enjoy, I hope you like it