Reporting
37 TopicsExcel Reporting : Can't connect to calendars with OData anymore (v2)
Hello everyone, Some of you may remember my previous thread about the same-ish issue (https://techcommunity.microsoft.com/t5/project/excel-reporting-can-t-connect-to-calendars-with-odata-anymore/m-p/4132119) that ended up being solved by a Project Online patch. But somehow, the issue returned. Not the same cause, since it has nothing to do with authentication this time, but the same symptoms : trying to fetch Calendar Exceptions data from an Excel OData query doesn't work anymore. When trying to get the data, I am getting "Error 400 : Cannot get a CSOM-compatible PJContext for an HTTP request that started outside of CSOM." It seems the issue started this morning on my client's tenant. Has anyone else experienced the same issue ?Solved258Views0likes8CommentsProject 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}2.5KViews0likes2CommentsHow 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.603Views0likes11CommentsPWA Data connections - OData Risks erros
Good afternoon everyone, I am trying to connect my PWA to PBI, and I can connect all the data connections except for the risks. Does anyone know if there is some incorrect configuration or if there is a workaround I can try? I have also tried to connect through SharePoint Online, but it does not find data related to risks. In case it's important, this PWA is already in the new settings. Thank you.414Views0likes1Comment"Finish" Value in Project Center
Hello Comrades, I was hoping that one of you may be able to help me clarify what value a field is displaying in the Project Online (PWA) Project Center. The field in question is the "Finish" field, shown below. Originally, we were assuming that this was the "Finish date" of the project set in the Project Information,in the Project desktop app. However, that does not appear to be true. As we have started to run into cases where projects are published and the "Finish date" in the Project Information section does not match the "Finish" value in Project Center. It seems as though Project Center is either showing the "ProjectLateFinish" date of the project OR the "Finish" of the top-level task in the project? I have been unable to find any documentation on what value is showing in Project Center. Thanks! ChrisSolved515Views0likes3CommentsRoadmaps 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, RobSolved1KViews0likes2CommentsAlternative to ODATA using MS Project SE (Subscription Edition)
Hi all, until last week we were using MS Project Server 2016 and visualizing the data from the PWA in Power BI via the ODATA Connector. Last weekend SharePoint and MS Project were upgraded to Subcription Edition (SE) on prem and now the ODATA interface is no longer usable. Do you have any idea how to make the data from the MS Project Server Subscription Edition PWA usable? Best AlexanerSolved1KViews0likes1CommentProject for the Web export to excel only columns in Grid view
When using the 'Export to Excel' feature it exports all columns. Is it possible to export only what is visible in the grid view? Or can I feature request a checkbox system for exports. Thanks. (Edit: Title 'Project Online' to 'Project for the Web')Solved1.1KViews0likes4CommentsMaking a roadmap diagram
Hi, I often have a need to create a roadmap view of my schedules in powerpoint for executives. Neither the gantt chart nor the timeline view is presentable enough. Of course I can manually take the data from MS Project file and put in excel and draw out charts, but it's very time consuming process. I am after a tool which takes MS project as input file and generates a roadmap view, which can be copy pasted in ppt. A bit of googling gave officetimeline.com , but it's paid tool. Is there a similar tool, but free ? Even if there is a template in which I copy paste schedule from .mpp file and the template generates a presentable roadmap view is good enough. Thanks.836Views0likes1CommentProblem inserting worked hours in Microsoft Project web page
I use Microsoft project web page of my company daily. Today I detected that I cannot insert hours in cells ( 1.2h + enter, does not work). After several tries and with another computer login accessing my hours page I detected that if I write the time value "1.2", for example, and I press the mouse in another cell, the hour enters. If I use enter in login of some computer does not enter and other computers enters around 1/3 of times. This did not happen previously. First day. Thanks in advance. Emanuel Martins740Views0likes5Comments