New feature for #Projectfortheweb with Export to #Excel #MSProject #MicrosoftProject #Office365 #Workmanagement #PPM

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 →

#ProjectServer 2019 missing data in #OLAP cube? #SSAS #Reporting #Excel

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 →

#ProjectOnline #PowerBI Currency Conversion Project Cost Report Part 2 #PPM #BI #Office365 #PowerQuery

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 →

Security trim Project data in #ProjectOnline #PowerBI #Excel #PowerQuery reports part 2 #PPM #Odata #REST #BI

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 →

Create a free website or blog at WordPress.com.

Up ↑