Project Online - Business Drivers matrix table in Power BI
Hi! After classifying our ongoing projects we could get to this matrix table in Project Online: There are 6 Business Drivers where each project contributes on a rating scale (None, Low, Moderate, Strong, Extreme) I am stuck on Power BI to find the relation between each Project, the rating scale and each Business Driver to be able to build the same matrix table in Power BI: Any help would be much appreciated!
Track equipment capacity in MS Project
Hello, I have decent experience using MS Project desktop but currently struggling with how or if MS project is able to track equipment capacity in terms of quantity/units. Ideally, I would like project to alert/show capacity for an equipment based on task start/end date show capacity for future planning. For example, I have 70 samples to run on the equipment but capacity is 40 samples. I know that the 70 samples can't go through, but how can I set the equipment capacity in project to call this out? I have been tinkering with resource sheets, names, %, but don't understand how to manipulate it so that if I set an equipment capacity at 40 units (not %), it will show me capacity alerts. I also want to enter in tasks that are happening months out and would like capacity alerts to be called out in this situation too. This is how I'm tracking it in project. I don't want to put each sample as it's own line item as there are many projects with X samples so I keep it as a high level task with the project and associated sample count. Maybe it's how I am tracking that doesn't allow for tracking capacity in units? Any suggestions are appreciated. Thank you.
Project web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://thoenigroup.sharepoint.com/sites/pwa/_api/projectdata The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advance
Project Online Task notes update using Rest Api
Hello, I am able to create a new task and then I can give the value for notes field which works fine but when I try to update the same "Notes " field then the update doesnt happen using the rest api I am using below rest api with Patch method _api/ProjectServer/Projects(<project_id>)/Draft/Tasks(<Task_id>) Body: {'Notes': value}RecipientEmailAddress but recipient information BEFORE DL expansion
I'm trying to get a list of the top email recipients in our environment using the EmailEvents table and RecipientEmailAddress in Defender 365/Sentinel. But, as the schema says, RecipientEmailAddress is the "address of the recipient, or email address of the recipient after distribution list expansion" How can I query on recipient info before DL expansion?
Bookings Report Automation?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities. I'm in a government account environment, so Power Automate isn't an option. MS Graph isn't an option. We're still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We're unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I've opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft's answer was "no." Has anyone else out there figured out a workaround to automate access to custom field data in government account environments?
