This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In project server i got the below data:
Task Name: "Develop Feature A"
Duration: 7 days
Start Date: 8 April 2024
End Date: 27 June 2024
% complete: 71%
remaining work 151.5 hours but when I extracted the Timephased dataset to power bi, i got the below: 24/06/2024 69.77 hours
25/06/2024 75.75 hours
26/06/2024 6.98 hours
the total of three days above is 151.5 hours, the project phased correctly of 9.6 hours in the first 5 days, but the upcoming weeks are 0
Could you please help with this?
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Dear User,
Thank you for posting in Microsoft Community. We are happy to help you.
Per the data you provided, it seems that there is a discrepancy between the remaining work in the project server and the extracted Timephased dataset in Power BI. The remaining work should match across both sources, but it appears to be different for the upcoming weeks.
If my understanding of the scenario is right, I recommend you double-check the data extraction process, ensure that the Timephased dataset is being extracted accurately from the project server to Power BI. Also verify that the data is being imported correctly, including the date ranges and corresponding work hours.
You may review the calculations or transformations being performed on the Timephased dataset within Power BI. Check if any filters or aggregations are being applied incorrectly, which may be causing the discrepancy in the remaining work.
In addition, I will keep this thread open. Welcome community members and MVPs who have similar experience to share suggestions here.
Thanks for your time and cooperation!
Hope you have a nice day!
Sincerely,
Tina | Microsoft Community Moderator