Forum Discussion

DataVitalizer's avatar
DataVitalizer
Super User
1 year ago
Solved

Reference dates from Project online not updated

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. 

  • DataVitalizer's avatar
    DataVitalizer
    1 year ago

    Hi Community,

    If you've faced the same issue as I did, after investigating, I succeeded in identifying and solving the problem. The issue actually comes from Project Online, and what you need to do is force a recreation of the baseline.

     

    Good luck

3 Replies

  • Hi DataVitalizer 

    Anything different about that column since you last refreshed?
    Name, data type, who it was assigned to etc

     

    Is it correct in the Query Editor but wrong in the front end?

    Clearing the cache can help, I've had data that refused to update even when clicking refresh.

     

    Is it wrong any time you connect to it or just in that report?

    Try connecting from a new PBIX and see if that helps.

    Check your Global connection settings. When you connect in a new report the old connection settings are saved under global.

    • DataVitalizer's avatar
      DataVitalizer
      Super User

      Hi SamWiseOwl ,

      Thank you for your response.

       

      The problem occurs only in the Start Date Reference and specifically with one project. After I updated the dates in the project online, all the projects updated in the report except for one project in one column. I previously tried connecting another report and clearing the cache, but the issue still persists.

       

      • DataVitalizer's avatar
        DataVitalizer
        Super User

        Hi Community,

        If you've faced the same issue as I did, after investigating, I succeeded in identifying and solving the problem. The issue actually comes from Project Online, and what you need to do is force a recreation of the baseline.

         

        Good luck