User Profile
RodFromm
Iron Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: 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)Re: 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.Re: 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 GetSelectedFieldsFromAnalysisRe: 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)Re: 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 · GitHubRe: 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.Re: 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.Re: 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.Re: 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.Re: 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=MSDNRe: Timesheet Single Entry Mode
I've seen this before. At the resource assignment level, when the Actual Work for the assignment doesn't match the hours entered in a user's timesheet MS pre-populates the timesheet with Actuals. It distributes the Remaining Work over the duration and applies it to the current and future timesheet when they are opened. To identify these issues, we created a Power BI report that compares the Assignment level Actual Work to Timesheet hours. When there is a difference just open the plan and update assignment level Actual Work to match Timesheet hours submitted.Re: Project web app- No up to date data via OData feed
For the currency issue. Try this first on a project that will publish to review the currency setting then try it a problem project. To set the project currency in Microsoft Project Desktop, follow these steps: Open Your Project: Start by opening the project file for which you want to set the currency. Go to Options: Click on the File tab to open the Backstage view. Select Options from the menu on the left. Access Display Settings: In the Project Options dialog box, click on the Display category. Set Currency: In the Symbol box, type the symbol of the currency you want to use (e.g., $ for USD, € for Euro). In the Placement box, choose where you want the currency symbol to appear (e.g., before or after the number). In the Decimal digits box, select the number of digits you want to display after the decimal point. Apply and Save: Click OK to apply the changes. Please note that these changes will only affect the current project. If you want to change the default currency settings for all new projects, you need to adjust the settings in Windows: Change the currency settings for your project - Microsoft SupportRe: It should be so simple…
If this is something that needs to be updated weekly/monthly by the customer I would look for a more robust solutions and put it in Project or Planner Premium. If this is something you will be doing periodically try the following options. Assuming there are no dependencies among the 100's of projects in your list this can be done in Excel or directly connected to Power BI. For Excel, go to File, New then search for a Gantt template.xls, which you should be able to easily modify to accept missing columns then just copy/paste your data, For Power BI, connect directly to your Excel file to ingest the data then add a custom Gantt visual. Be forewarned as many of the Gantt custom visuals leave a lot to be desired.Re: Microsoft PowerBI Template and Project Web App
This will be difficult to provide an answer without seeing the file. What is the filename of the template and did you download it off GitHub? Did you modify the template, or use it as is? For the visual displaying the incorrect information can you hover over each field and provide the table and field name for each item?Re: You don't have permission to access items on this site
To create or access a Roadmap. Go to the "https://project.microsoft.com/<your url>/en". To create click + New plan the Roadmap. Existing Roadmaps you have access to, should be available on the bottom of the same page, or they can click the link in the email they received when assigned to the Roadmap.
