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... Continue Reading →

#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... Continue Reading →

#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... Continue Reading →

#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... Continue Reading →

#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... Continue Reading →

#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://gallery.technet.microsoft.com/Online-Power-BI-Report-abcb3c3b This report pack consists of 8 reports for... Continue Reading →

#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... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑