Building a #PowerApps app for #MSProject data Summary post #SharePoint #PowerPlatform #PowerAutomate #LessModeMorePower #NoCode #CDS #Office365 #PowerBI

This is a quick post to link to all of the blog posts in this mini series for building an app for the Microsoft Project SharePoint task list data. The links can be seen below along with a link to a video showing the app: Part 1: https://pwmather.wordpress.com/2020/04/16/building-a-powerapps-app-for-msproject-data-part-1-sharepoint-powerplatform-powerautomate-lessmodemorepower-nocode-cds-office365/ Part 2: https://pwmather.wordpress.com/2020/04/25/building-a-powerapps-app-for-msproject-data-part-2-sharepoint-powerplatform-powerautomate-lessmodemorepower-nocode-cds-office365/ Part 3: https://pwmather.wordpress.com/2020/04/27/building-a-powerapps-app-for-msproject-data-part-3-sharepoint-powerplatform-powerautomate-lessmodemorepower-nocode-cds-office365/ Part...

#ProjectOnline #PPM #PowerBI Project Compliance Report Pack #BI #Reporting #PowerQuery #DAX #Office365

This is a supporting blog post for a new Project Online Power BI Report Pack that I have published. This report pack provides examples for a project compliance / audit type check to ensure your projects follow certain planning standards. This follows on from the previous report packs that I published: https://pwmather.wordpress.com/2017/10/31/projectonline-ppm-powerbi-report-pack-v2-bi-reporting-powerquery-dax-office365/ This new report...

Reporting on #ProjectOnline Resource Cost Rate Tables #Office365 #PPM #PowerBI #Excel #PowerQuery #MSProject

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...

#ProjectOnline time phased data rollup for #OData reporting note #PPM #PMOT #BI

Just a quick post to highlight a feature in Project Online when changing the rollup of timephased reporting data in Project Online as posted here: https://pwmather.wordpress.com/2017/11/17/projectonline-time-phased-data-rollup-for-odata-reporting-ppm-pmot-bi-excel-powerbi/ As per the Microsoft support article below: https://support.office.com/en-us/article/Configure-rollup-of-timephased-reporting-data-in-Project-Online-da8487fe-899e-4510-a264-e2ebc948928c This mentions only the following endpoints in relation to this change: You will also find that the ResourceDemandTimephasedDataSet endpoint is also...

#ProjectOnline #PowerBI Report – Include #HTML formatting #PPM #PMOT #PowerQuery #OData #REST Part 3

Following on from my 2nd post in this mini series on reporting including HTML formatting in Power BI, in this post we will look at a couple more options that will refresh in the Power BI App Service. If you missed the previous posts, the links are below: Part 1: https://pwmather.wordpress.com/2018/01/01/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-1/ Part 2: https://pwmather.wordpress.com/2018/01/03/projectonline-powerbi-report-include-html-formatting-ppm-pmot-powerquery-odata-rest-part-2/ The...

#ProjectOnline #PowerBI Report – Include #HTML formatting #PPM #PMOT #PowerQuery #OData #REST Part 2

Following on from my first post discussing including HTML formatting for Project Online Power BI Reports, in this post we will look at a summary of options to get the correct data into Power BI then walkthrough one of those options. In part 3, the final part, we will look at one of the other...

#ProjectOnline #PowerBI Report – Include #HTML formatting #PPM #PMOT #PowerQuery #OData #REST Part 1

My first post for 2018, Happy New Year to all! This post is the first of 2 or 3 posts covering HTML formatting in your Power BI reports from Project Online multiline project level custom fields as seen below – screenshot from mock up / demo data: For those of you that are familiar with...

#ProjectOnline time phased data rollup for #OData reporting #PPM #PMOT #BI #Excel #PowerBI

Recently it was announced that it would be possible to rollup some of the data in the time phased feeds for Project Online, the support documentation can be found here: https://support.office.com/en-us/article/Configure-rollup-of-timephased-reporting-data-in-Project-Online-da8487fe-899e-4510-a264-e2ebc948928c Currently today in Project Online, the time phased data is stored in the Reporting schema at the day level. For some organisations, this is...

#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...

#ProjectOnline #PowerBI content pack 2 available #BI #Office365 #PPM update

Following on from my previous blog post regarding the updated Project Online Power BI content pack from Microsoft -  see below if you missed it: https://pwmather.wordpress.com/2017/09/26/projectonline-powerbi-content-pack-2-available-bi-office365-ppm/ That was shortly removed from the Power BI service and hasn’t been updated there yet but the template file has since been made available to download from GitHub: https://github.com/OfficeDev/Project-Power-BI-Content-Packs...