Business Intelligence
14 TopicsStart 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 here109Views0likes1CommentHow 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.607Views0likes11CommentsRoadmaps 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, RobSolved1KViews0likes2CommentsAutomatically 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 myself941Views0likes3CommentsProject Web App: Power BI Templates for Timesheet Data?
Hi Tech Community, I'm relatively new to PWA and creating reports in Power BI I have created a couple of custom reports with Power BI, using the OData source and I'm now looking to build a report based on Timesheet data and monthly activity for different resources. I'm just wondering if any Power BI templates have already been made available for this purpose? I downloaded and installed the Project Web App Power BI reporting extension but that didn't seem to include any Timesheet Specific ones. I note that there are a bunch of Tables in the OData specifically pertaining to the Time Sheets, so Iām currently investigating that š one challenge is that my PWA environment is in French and so all my table names are in French and differ greatly in nomenclature to the English references sited in the forums. Thanks in advance for any insight and comments,Solved7.3KViews0likes2CommentsTime Sheets - PWA - Custom Enterprise column not displaying
Hello, I'm hoping someone can help, I have set up a custom text field with data that I want to use and display in the Time Sheet view of PWA for a selection of users as I need to be able to report on data in this custom field and lookup table for a specific project. Although everything seems to be fine with the created Colum and corresponding look up table, I cannot get the field to display for a selection of users, even though it is present in my Ms Project professional desktop app (as an entreprise field) and in the enterprise data of PWA When in PWA views, I can customise the view and select the custom Colum to be displayed in time sheet data, but it will only show up for a bunch of users and not all users, I'm guessing there is something I need to modify in the User permissions, groups and categories and security temaplates, but amongst the plethora of PWA settings I cannot find the right one to display the said custom field and look up table for all users after quite a lot of searching. Any help or insights would be very much apricated. Best regards, LisaSolved1.2KViews0likes1CommentMS Project Online Desktop Client - Showing Work for Each Resource per Task
Hi All, Does anyone know of a way to show the level of effort (or work) of individual resources per task? Specifically when a task has multiple resources assigned? Ideally I'd like to be able to generate a table as depicted below Task LoE for Resource A LoE for Resource B LoE for Resource C Develop methodology 10hrs 25hrs 3hrs Develop tool 40hrs 80hrs 15hrs Use tool 8hrs 40hrs 5hrs Any help would be greatly appreciated. Kind regards, ChristianSolved973Views0likes3CommentsNeed help with Project Online - Custom field (text) - PowerBI
Hello, I have created several custom fields (text value, Multiple lines of text) in Project Online, Project level. However, when the fields are imported in powerbi, the carriage return is not recognized by powerbi and all lines appear in 1 line ! For example: Project online: Next month activities (text field): the following texts are entered within the field: - Finalize business case - Define deliverables at high level - Define key milestones PowerBI: Next month activities (text column) - Finalize business case - Define deliverables at high level - Define key milestones Can you please help ! Thank youSolved1.8KViews0likes3CommentsIs possible to Share resource hours & Availability between multiple PWA
Hi All, i am using a default PWA from last 5 year andi have created new PWA now, but the resource availability can't be use from old PWA but i have project already schedule in old PWA and some resource need to schedule / use in both PWA. Is any possibilities to share the resource availability and hours between different PWA. ThanksSolved719Views0likes1CommentProject Server:Build a datawarehouse
Hi everyone, I am totally new in Datawarehouse and I'm just asking if there is an utility to build a datawarehouse with Project sever Data Or these databases are already optimize to build report? Or am I just wrong in my understanding of a datawarehouse? A datawarehouse should be build for Historical data or Integration with other system but if the only purpose is to create reports with data from Project Server a datawarehouse is not required? Thank you for your inputs š389Views0likes1Comment