Inconsistency between Dataverse and Project Web - Task Completion Percentage (msdyn_progress)

Question

Inconsistency between Dataverse and Project Web - Task Completion Percentage (msdyn_progress)

Winston Jones 20

Greetings,

I am trying to use Power Bi to simply display Project for the Web or Planner data...I have tasks that are reporting 100% in Planner but they are showing as 0% in the Dataverse. However, this issue does not happen to all 100% complete tasks Planner...it appears to not be related to LOE either since that is completed as well. There is no indication as to why there is this problem. I cannot accurately report from the Dataverse if the data contained does not match the source data or Planner data consistently. Please advise.

Regards,

WCJ

2026-08-31_16-36-11

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Jay1 Tran 515 Independent Advisor

Hi Winston,

Thank you for reaching out and for providing the details and screenshots.

The issue appears to be a synchronization inconsistency between Planner and Dataverse. Planner processes task updates through the Project Scheduling Service, and those updates are then written to Dataverse. In some cases, the task can display as 100% complete in Planner while the corresponding Percent Complete value in Dataverse remains at 0.00.

Because Power BI reads the task data from Dataverse, Power BI will also display 0%, even though Planner shows the task as complete. This indicates that Power BI is reporting the available Dataverse value correctly, but the underlying Dataverse record has not been updated as expected.

To resolve the issue, please try the following steps:

Open an affected task in Planner.
Change the task completion percentage from 100% to a lower value, such as 99% or 0%.
Save the task and allow the change to complete.
Mark the task as 100% complete again.
Wait several minutes, then refresh the Project Tasks table in Dataverse.
Confirm that the Dataverse value changes from 0.00 to 1.00, where 1.00 represents 100%.
Refresh the Power BI dataset after Dataverse displays the correct value.

If the value remains at 0.00, a Power Platform administrator should review the Operation Set and Project Scheduling Service error logs under the Schedule Integration settings. These logs may identify a failed or incomplete task update.

Please do not manually change the Percent Complete value directly in Dataverse, as this could create further inconsistencies with the Planner scheduling engine.

I hope the information I shared earlier was somewhat helpful in addressing your issue. If you have any further questions or updates, please don’t hesitate to share. I’m always happy to assist further if needed.

Jay1 Tran 515 Reputation points Independent Advisor

2026-09-01T22:42:00.0633333+00:00

Hi Winston,

Have you reviewed the provided answer? Please let me know if there are any updates.
Winston Jones 20 Reputation points

2026-09-01T22:45:52.6566667+00:00

Greetings Tran,

I am going to try it...thank you for your reply and possible solution.

-W
Winston Jones 20 Reputation points

2026-09-02T14:10:39.5466667+00:00

Tran,

I just tried it...and it worked. Out of ~40 tasks 9 random tasks did not want to show % complete of 100%. I will try the fix on the remainder. I hope they don't randomly revert back...hehe. Thank you much for the help. Great work around. I am using Planner, Power Bi, and Dataverse in a GCC area...these issues need to be resolved at Microsoft.

Regards,

Winston
Jay1 Tran 515 Reputation points Independent Advisor

2026-09-02T16:18:04.32+00:00

Hi Winston,

Thank you for the update.

I’m glad the workaround was successful for most of the tasks. Hopefully, the remaining tasks respond to the same fix and the changes remain in place.

If you need Microsoft to investigate the issue further, please contact your IT administrator and ask them to open a support ticket with Microsoft. The support team can review the behavior in your GCC environment and provide further assistance with Planner, Power BI, and Dataverse.

For instructions on submitting a support request, please refer to: Get support - Microsoft 365 admin | Microsoft Learn.

In case you do not know who is your IT admin, kindly refer to this article: How do I find my Microsoft 365 admin? - Microsoft Support

Thank you for your time and understanding. Wishing you a great day ahead.