Table of Contents
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
Microsoft Project (MSP) is one of the most used Project Management tools across Enterprises and is a part of the Microsoft Office offerings. There are multiple MSP offerings, both on the client side as well as on the Server side. On the client side, we have Project Professional and Project Standard. On the Server side, we have Project Server 2013/2016 (On Premises) and Project Online (Cloud Offering). While you have complete access to Project Server Databases in the on-premises version, you only have limited OData feed access in Project Online which limits your options for custom reporting. In this post, I am going to focus on what options you have for Business Intelligence Reporting in Project Online with Power BI and Excel.
Out of the box, you have sample reports that you can use as a reference point for starting with reporting on your projects. To open the sample reports, you need to do the following:
Click Settings > Site Contents > Reports > Choose Language > Open the language folder, and there you’ll see the sample reports.
PowerBi for Office 365 is discontinued and you will not be able to access it.
This Report shows data on Projects, AssignmentWork, and AssignmentActualWork by ProjectName. Additionally it shows Count of TaskId by ProjectName
This Report shows Project Name, Percent Complete Count of Assignments and Tasks
This is more Resource focused and shows data like Assignment Work and Actual Work and Count of Tasks by Resource.
These reports provide high-level details about all your projects using a combination of the six pre-built OData connections that comes with Project Online. The data can be refreshed, and the latest data is always available.
As you can see from the image above, you can go ahead and create additional reports from the OData connections available like I have in my MSP Online tenant.
Clicking on this option takes you to the PowerBI online portal where you can connect to Project Online using a Microsoft Project Online Content Pack. The content pack is a set of Pre-Built Reports and Dashboards which gives your a complete end to end view of your current projects.
Once you click on “Connect” you would need to enter your Project Online URL information.
Select oauth2 and Sign In
Click on Sign-In and then Provide your O365 credentials to access your Project Online Data.
Once you have provided your O365 credentials, PowerBI takes some time to import the data into PowerBI.
Once the Import is complete, you can access the Dashboard to view your Project details
You can also use the Quick Insights Option to see more Reports without writing any custom code.
Once the reports are ready, you can view them from the same location.
Using Excel can enable you to analyze and explore data views and format them in charts and tables. After creating reports in Excel, you can share interactive reports, scorecards, and dashboards to Power BI, SharePoint, etc. Using tools like Power Query, Power Pivot, Power View, and Power Map you can create powerfully, interactive views and mashups in Excel. You can:
To create a report in Excel, you need to do the following:
Projects?$filter=ProjectStartDate gt datetime'2014-01-01T00:00:00'&$orderby=ProjectName&select=ProjectName,
This method is typically suited for Advanced users who are comfortable with combining data and creating custom reports.
It is strongly advised to you to read the official documentation for more In-Depth Information. Here are the Online References:
Comments are closed.