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!
Querying Custom Text Fields from MS Project Online
I am trying to call custom text fields (Text1, Text2, ...., Text30) from MS Project Online using OData feed i PowerBI. When I use {pwaUrl}/_api/ProjectData I am able to get the default fields on top of the custom enterprise fields but not the custom Text fields. Is there any way to query these custom text fields?
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://company.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 advanceStart reference date not refreshed in report
Hi Community, I've created a Power BI report based on data from Project online. I changed few dates for certain projects in Project online. When I refresh the data in PBI Report, all project dates update correctly except for one specific project, where the reference date still show the old value. Any suggestion would be appreciated. Dale_HowardMVPAllow me to mention you here
How to surface Project Online resources added to a project but have no assignments in Power BI
In Project Online, we add resources from our enterprise resource pool to projects using the "build team" functionality. Once the team is built for a project we may or may not assign some or all of those resources to tasks in the project. I want to create a Power BI report that shows all of the resources on a project team regardless of whether they have assignments or not. I can get the resources that have assignments, but I cannot figure out how to surface the resources that are on the project team but do not have assignments.
Roadmaps tables missing after installing Project for the Web in a new environment
I've just installed Microsoft Project Service core and the Project Management Office Accelerator to a new environment. This appeared to be successful (apart from a known error with one of the flows in the Accelerator), and I and was in the process of setting up a PowerBI dashboard from the template when I encountered a "key didn't match any rows in the table" error, affecting all the Roadmap tables: Checking the tables in the environment, I find no tables matching msdyn_roadmap, while they are present in the default environment. I find 24 tables matching msdyn_project in both environments. Have I missed a step, or is there something else going on? I do notice that there are two entries for Microsoft Project Service Core under Resources > Dynamics 365 apps in Power Platform Admin Center (I didn't notice this when carrying out the initial install). Going into Details for each of these, I can't see any difference: Thanks, Rob
Automatically download dashboards from Microsoft Project
Hello everyone I have a strange question for you users: I have many projects in Microsoft Project. Everyone of them is a Gantt Diagram updated daily. Then I have a main project, where everyone of the others is linked in, so in the main project you see the Gantt Diagram of the progress of the others projects. Ok, then, every project (also the main one) has a dashboard (project overview), where you can have a graphic visuali of the progresses. I basically have to show all of these dashboards to my boss every week. They are a lot of projects and I need to show him all of them. Is there a way to get these dashboards automatically? In every format that is readable? thank you, sorry for my English, I hope I explained myself
