web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Dataverse planner Prem...

Power Automate

Unanswered

Dataverse planner Premium into BI ( Date of goal in msdyn_projectgoal)

(0) Share

Report

Report

Posted on by HS-01041609-0

Im on the way to finish my BI Dashboard, nevertheless Im Stuck a little bit!!

Im Trying to get Date of Goals in Dataverse (Up to know without successes!) Logic is to have Variance day between Goal Date vs Task Finish date.

I check already all fields into msdyn_projectgoal and can not get it.

I appreciate your support .

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Sunil Kumar Pashikanti 2,097 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @HS-01041609-0,

msdyn_projectgoal does not store a Goal Date.
Project/Planner Premium treats goals as derived, not date‑based records.
To calculate variance, join msdyn_projectgoal to the related Project Task and use fields like Planned Finish or Scheduled Finish for your date comparison in Power BI.

Where to Get the Dates You Need
Use These Related Tables Instead:

msdyn_projecttask

msdyn_plannedstart
msdyn_plannedfinish
msdyn_scheduledend

(Optional depending on setup)

Resource assignments
Project buckets / milestones

Power BI Pattern

Load:

msdyn_projectgoal
msdyn_projecttask

Join by:

Project ID
Task reference (if present)

Create DAX:

VarianceDays = DATEDIFF ( 'ProjectTask'[PlannedFinish], 'ProjectTask'[ActualFinish], DAY )

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Was this reply helpful? Yes No

Join the conversation