Project Online and PowerBI

Bring your Project Data to LIFE

PowerBI and Project Online

In today's fast pace corporate world PMs, PMO, and Resource Managers need to be able to access project reports from anywhere and on any device and the challenge is to have report developers design and publish interactive project reports such as resource utilization, project portfolio, project demand, risks and issues, time phased data and project financial info in a timely manner.

PowerBI allows you to easily connect to your Project online instance and in minutes, transform your project data into stunning, interactive and fluid visualization.

Use PowerBI Desktop or Excel 2013 and choose Get Data to connect to the oData feed.
Choose https://(yourtenant).sharepoint.com/sites/pwa/_api/Projectdata and select the tables you want to report on. Next, you can model your data in PowerPivot or publish your reports directly to PowerBi.com.

More Info on https://powerbi.microsoft.com

SharePoint Alert Queue

I was trying to find an easy way to see the alert queue in our SharePoint WSS 3.0 envrionment and I came across the SQL table called [SchedSubscriptions] and took a look at it and sure enough there were all the open alerts, including username, website and email, etc.

So all u need to do is delete all records in the table.

There is also another table called [ImmedSubscriptions] which shows you the current alert settings.


Ross G