User Profile
RodFromm
Iron Contributor
Joined Jan 13, 2023
User Widgets
Recent Discussions
Re: Planner and Projects 3 online - getting this onto desktop app
It's not possible to open/edit a Planner project with MS Project Desktop software. Many have ask for this, but Planner is a very lightweight PM tool and I doubt we will ever see this integration with the MSP desktop app.72Views0likes0CommentsRe: Data access after Project Online (PWA) retirement
I probably should have been clearer but in the conversations, I've had with Microsoft they stated the MSPO data will not be accessible after MSPO is retired. Here is the official announcement, which you've probably seen Microsoft Project Online is retiring: What you need to know | Microsoft Community Hub126Views1like0CommentsRe: Data access after Project Online (PWA) retirement
Unless Microsoft changes their stance, none of the data in your MSP Online tenant will be available after MSP Online is retired. We are making plans to move our OData (used for Power BI reporting) to the dataverse then migrate our MSP Online PWAs over to MS Project Server SE.202Views1like0CommentsRe: Crews in Planner in Planner/Project accelerator
Planner currently does not natively support this. You either do it manually or possibly create a flow that is triggered when the crew resource is assigned then multiples the effort. I don't know if the flow option actually works and would probably be problematic. Another option would be to handle this in Power BI reporting by multiple the crew resource effort by X.175Views2likes0CommentsRe: Resources mapping using Project (Planner) and MS Power BI template
To make this happen you need to two pieces of information: Planned Work and Resource Availability (hours). Here is a high-level overview of what's needed. It's assumed you have some Power BI DAX and data modeling skills. Planned Work - The Resource Timephased table has the Planned Work (PW) with a Planned Work Start (bins) column that allow you to group PW by month. Ensure the Planned Work Start data is related to your Date field in your Calendar table. Resource Availability (hours) - This doesn't exist in the template. You can create a table contains the monthly availability of each resource. Add this table to your model and related it your Bookable Resources table Using the Planned Work and Resource Availability information create three measures. One for Planned Work, another for Resource Availability and the final one for your monthly percentage. As a reference, here is an example of the measures. The field names won't match your templated, but you get the idea. Total Planned Hours = SUM('Planned Work'[Planned Hours]) Total Available Hours = SUM('Resource Availability'[Available Hours]) Utilization % = DIVIDE([Total Planned Hours], [Total Available Hours], 0)153Views0likes3CommentsRe: Project Online - Business Drivers matrix table in Power BI
Based on your spreadsheets the relationships appear to be present, but they don't let you access the table/fields that contains the Business Driver values: Extreme, Low, Strong, etc. Wish I could offer additional suggestions, but we do not have this feature enabled.58Views1like1CommentRe: Project Online - Business Drivers matrix table in Power BI
Try this and see if you can extract the PrioritizationId from the Analysis record. I don't have this functionality enable in my PWA so you may have to fiddle with it a bit to make it work. Steps to Create and Use the fxGetPrioritizationIdByAnalysisId Function Create the Function Query In Power Query, create a new blank query. Name it fxGetPrioritizationIdByAnalysisId. Add the Function Code Copy and paste the provided code into the fxGetPrioritizationIdByAnalysisId query. Apply the Function in Your Data Go to the PortfolioAnalysisProjects query. Click Add Column > Invoke Custom Function. Configure the Function Invocation Set the new column name to: PrioritizationID. Choose the function query: fxGetPrioritizationIdByAnalysisId. For the parameter, select the AnalysisId column. Finish Click OK to apply the function and generate the new column let GetSelectedFieldsFromAnalysis = (analysisId as text) => let url = "https://<your PWA URL>/_api/ProjectData/PortfolioAnalysisProjects('" & analysisId & "')/Analysis", result = OData.Feed(url, null, [Implementation = "2.0"]), record = result{0}, selectedFields = Record.SelectFields(record, {"PrioritizationID", "AnalysisName", "CreatedDate"}) // Add more fields as needed in selectedFields in GetSelectedFieldsFromAnalysis30Views1like3CommentsRe: Project Online - Business Drivers matrix table in Power BI
Here is my take on this given the limited info I have about your model and other requirements. If nothing else this may give you some ideas on how to accomplish your end goal. I would build a new table in Power Query as follows. Load All Tables: Project PortfolioAnalysisProject PortfolioAnalysis PrioritizationDriver BusinessDriver Merge Queries: Start with Project Merge as New table with PortfolioAnalysisProject on ProjectId Merge with PortfolioAnalysis on AnalysisId Merge with PrioritizationDriver on PrioritizationId Merge with BusinessDriver on BusinessDriverId Select and Keep Only: Project[ProjectName] BusinessDriver[DriverName] (A–F) PrioritizationDriver[DriverValue] (None–Extreme) Name new table BuinessDriverMatrix?? and establish relationship to Project table Pivot the Table: Select DriverName column → Pivot Column Use DriverValue as the Values Column In the pivot settings, choose Don’t Aggregate (or use “Max” if needed)72Views1like0CommentsRe: P4W relationships in PowerBi
I'd recommend you download the free Project for the Web Power BI template, see link below, and review it as it will cut down your development time. It would also help if you would provide the table names you are trying to relate. We need to ensure you are using the correct table/fields name. Project-Power-BI-Templates/Project for the Web at master · OfficeDev/Project-Power-BI-Templates · GitHub85Views0likes1CommentRe: Unique identifier for tasks in Project on the Web
Just open the project, select a task and the projectid and taskid will be displayed in the address bar. It will look like this https://project.microsoft.com/- your tenant -/en#/taskgrid?projectId=222eee37-ee45-eeee-eeee-eeeef8501f6a&taskId=99EEA999-9990-F991-9A99-9999BDD3B999&taskMode= You can also copy the task and paste the value into notepad, but it contains more info and is harder to decipher.122Views0likes0CommentsRe: Project for the Web - % complete calc error
I tried reproducing the error as you described, but the calculations, while odd at times were correct. My example was a single task with one resource assigned and no dependencies or constraints. In your example assuming you have dependencies, check the task Dependency Type, Delay Type and ensure you no task constraints set as all of these can impact the calculations. Also, in your example you mentioned you could % values didn't return to the original value even when setting all the values back to original. This is possible depending on the amount of change you made. More details would help and as previously mentioned the order in which the changes are made can impact the calculations.60Views1like0CommentsRe: Save as a current project to a Project template via Teams Channel
Microsoft hasn't enabled the ability for you to create new a template or template from an existing plan. I doubt you will ever see this the default environment, but hopefully we will see it in named environment in the not so distance future.59Views1like0CommentsRe: MSP online: How to fetch all the TASK relationship?
Is there a reason you have to call each task individually? If not, refer to my post to get all TaskLinks in one call, or you could write a function to retrieve them one project at a time? It's hard to provide an answer without knowing what your process/requirements. Regarding documentation.....good luck MS Project Online is not supported and documentation is sparse at best.102Views0likes0CommentsRe: Timesheet or time tracking functionalities in Project for the Web/Planner Premium
They removed timesheet functionality from the roadmap months ago, which indicates they have no intention of adding that functionality anytime soon. As Paul mentioned, there are vendors that offer a solution, or you could build your own in PowerApps. To me the bigger concern is what's the future of Project Online, given it is no longer supported, and it appears Planner Premium isn't going to be built to replace Project Online.347Views0likes0CommentsRe: MSP online: How to fetch all the TASK relationship?
I do something similar in Power BI. The ProjectServer TaskLinks endpoint contains the task successor/predecessor, task type, etc information. you'll need. https://<PWA>/_api/ProjectServer/Projects?$select=ProjectIdentifier,TaskLinks This link contains the definition of the DependencyType field in the TaskLinks table https://learn.microsoft.com/en-us/previous-versions/office/project-class/jj232950(v=office.15)?redirectedfrom=MSDN153Views0likes2Comments
Recent Blog Articles
No content to show