Forum Discussion
ITManuelBI
Jan 13, 2025Copper Contributor
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 advance
- RodFrommSteel Contributor
For the 23000 and 26000 errors Microsoft recommended the instructions below and it has always resolved these errors.
- RodFrommSteel Contributor
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 Support- ITManuelBICopper Contributor
Hi @ RodFromm,
now I have only the two jobs left with "Project Name" = "N/A". To which project does this refer? The Enterprise Global?
- ITManuelBICopper Contributor
Hi RodFromm and Paul Mather
I have checked out, republished and checked in again all 34 projects, also the Templates and the Enterprise Global has been checked out, saved and checked in again.
Now it seems that i do get updated data ( looking at the "Lastpublished" date from the Projects table ) for some projects but not for all of them.
Paul_MatherHow can I check the endpoints directly? Looking directly in the PWA project center I can see the updated data ( looking at the "Lastpublished" date ), but not in the Projects table submited.
- ITManuelBICopper Contributor
Hi RodFromm
I have now checked out, republished and checked in all 34 projects. I also checked out, saved and checked in the templates and the Enterprise Global.
Some projects now seem to be updated ( ckecking the "Last published" date ) but not all projects.
how can I check the endpoints directly? I'm checking the date in the PWA project center. There, any update seems to be reflected.
Hi ITManuelBI ,
You mentioned OData feed - I'm referring to checking the data in those endpoints directly in the browser or in Power BI without any transformations etc.
If the data is not showing in the Project Center, I'd check the Manage Queue page for any failing / failing and blocking jobs preventing the publish jobs.
Paul
- ITManuelBICopper Contributor
Hi Paul_Mather ,
I've checked the data in PowerBI wihtout any transformations, the behaiviour is the same. The data shows correctly in the Project Center, but not in the submited data.
I have the following jobs in the Manage Queue:
The job from 14.01.2025 was not present last week when the issue started to appear. The error message of that first job is:
The error message of the other 2 jobs is "Root element is missing."
Hello ITManuelBI ,
Have you taken your Power BI report out of the equation and checked the endpoints directly, do they show the data you are expecting?
- ITManuelBICopper Contributor
Hi Paul_Mather
how can I check the endpoints directly? I'm checking the data in the PWA project center, there it reflecting any update but not or only partially ( for certain projects ) in the submited tables via OData feed.
- RodFrommSteel Contributor
Open your projects and Publish them then refresh the reports.
- ITManuelBICopper Contributor
I have checked out, republished and checked in all 34 projects, 2 templates and the Enterprise global.
Some projects now seem to be updated ( checking the "Last published" date ), others don't.