Modern Work Management – Project and the Power Platform blog
Microsoft Project, Project Online, Project for the Web and the Power Platform
Starting to rollout (so your tenant might not have this yet but it will soon) is the ability to export a Project for the web project to Excel. This is the feature detailed here on the roadmap: https://www.microsoft.com/en-us/microsoft-365/roadmap?featureid=67149. Once this reaches your tenant you will see a new ellipsis action button on the top right... Continue Reading →
Just a quick post and one related to Project Server on-premises which I haven't done for a long time! A colleague escalated an issue to me where by data was missing in the OLAP cube in a new Project Server 2019 deployment. The symptoms where that data appeared to be missing from the Portfolio Analyzer... Continue Reading →
The resource cost rate table details are not available in the Project Online / Project Server OData Reporting API (_api/ProjectData) but they are accessible using OData but from the CSOM REST API (_api/ProjectServer). In this blog post, I will walkthrough getting this data into an example Power BI report. It wont look pretty, that’s not... Continue Reading →
Just a quick post to highlight an issue I came across that I thought might be worth posting about in case anyone else runs into the same issue. In Project Online, in PWA you can export most of the grids to Excel. I was testing something in PWA and came across an issue exporting the... Continue Reading →
Following on from my first post on currency conversion found below: https://pwmather.wordpress.com/2017/03/06/projectonline-powerbi-currency-conversion-project-cost-report-part-1-ppm-bi-office365/ This post walks through a different option for working with multiple currencies. This post will create a similar report as seen below: This report enables the project cost to be calculated based on project currency and rate for the year. In this example... Continue Reading →
Whilst Microsoft’s Office 365 PPM tool Project Online supports projects using different currencies, there is no conversion based on a currency rate. The project has a currency set and the correct currency symbol is displayed for cost data. In the reports and views there is no conversion based on an exchange rate between currencies. This... Continue Reading →
Further to my last post on an example method to security trim the Project data in a Power BI report for Microsoft’s Project Online PPM tool, another option is to merge the datasets / tables. If you didn't see the first post, a link can be found below: https://pwmather.wordpress.com/2016/12/09/security-trim-project-data-in-projectonline-powerbi-reports-ppm-odata-rest-bi/ For this post, I have the... Continue Reading →
The reporting API for Microsoft’s PPM solution – Project Online doesn't filter the data based on the access model in PWA. For some organisations this can be problematic. In this blog post I show a simple report example to filter only projects and project milestones that I have access to in PWA. In this example... Continue Reading →
This post covers a new resource path in the OData endpoint for Microsoft’s PPM tool Project Online to give you the data you need for true resource demand for project assignments and resource engagement assignments. Before resource engagements were introduced, you could have assignments in the project plans or in the resource plans. For reporting,... Continue Reading →
Recently you might have noticed that the Project Online OData reporting API has been updated to remove the HTML tags, I tweeted about this last week. So before this changed the data would have look like this: Notice the HTML tags such as and </li></ul></ul></ul> in the StatusSummary field. In the PDP the data... Continue Reading →
Modern Work Management - Project and the Power Platform blog 
You must be logged in to post a comment.