SharePoint (and Project Server) Shenanigans

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

The Project Online Power BI content pack is now available – take a look today!

Log in to your Power BI site, click Get Data then click Get on the Services card under the Content Pack Library:

Scroll down the list and you will see Microsoft Project Online:

Click the tile:

Then click Connect and type the PWA URL – I connected to one of our demo instances:

Click Next and change the Authentication method to oAuth2 and click Sign in:

When prompted, enter the credentials.

The content pack will then be deployed to your workspace, it will first import the data as displayed in the top right hand corner:

Once completed you will see the Microsoft Project Dataset, Report and Dashboard accessible in the left navigation pane:

There are default reports for Issues:

Risks:

Portfolio Status:

Project Compliance:

Then there is a dashboard that displays some of this data:

Awesome work from the Project team at Microsoft 🙂