I am trying to find the information for who is "Assigned to" a task on the Project Task Table "msdyn_projecttask" so that I can make a PowerBI visual to show how many tasks a user is assigned to across multiple projects. I can't figure out which column/table has this info?
a bit late, but Assigned To data is stored in the table msdyn_resourceassignment table. The person is shown in bookable Resource.
(Thank Copilot for this)
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.