Forum Discussion

ITManuelBI's avatar
ITManuelBI
Copper Contributor
Jan 13, 2025

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

  • RodFromm's avatar
    RodFromm
    Steel Contributor

    For the 23000 and 26000 errors Microsoft recommended the instructions below and it has always resolved these errors.  

     

    • RodFromm's avatar
      RodFromm
      Steel 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:

      1. Open Your Project: Start by opening the project file for which you want to set the currency.
      2. Go to Options:
        • Click on the File tab to open the Backstage view.
        • Select Options from the menu on the left.
      3. Access Display Settings:
        • In the Project Options dialog box, click on the Display category.
      4. 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.
      5. 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

       

      • ITManuelBI's avatar
        ITManuelBI
        Copper 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?

  • ITManuelBI's avatar
    ITManuelBI
    Copper 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. 

  • ITManuelBI's avatar
    ITManuelBI
    Copper 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.

     

    Paul_Mather

    how can I check the endpoints directly? I'm checking the date in the PWA project center. There, any update seems to be reflected.

    • Paul_Mather's avatar
      Paul_Mather
      MVP

      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

      • ITManuelBI's avatar
        ITManuelBI
        Copper 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?

    • ITManuelBI's avatar
      ITManuelBI
      Copper 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.

  • RodFromm's avatar
    RodFromm
    Steel Contributor

    Open your projects and Publish them then refresh the reports.

    • ITManuelBI's avatar
      ITManuelBI
      Copper 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.

Resources