Retrieving Planner Premium fields in PowerBI and Power Automate

Seeing how the earlier mentioned MS Learn link has the UTM tags from my original article, might as well share the direct link to it, too.😁

Microsoft Planner and the revenge of MS Project

In short, Planner Premium data is not available via Graph API since it lives in Dataverse. This has been the case for past ~2 years and Microsoft hasn't yet delivered any readymade Planner connector to overcome this issue. While reading data from Dataverse is fairly simple with Power Automate cloud flows, to perform updates (or creates) on the plan data requires using the Project Scheduling Service APIs.

It's a lot of work to get them set up initially (compared to the Planner Basic connector). However, once you get the set up, it's not that bad actually. The hurdle with the first automation can be overwhelming if you don't have Dataverse / Dynamics 365 experience, though. I've been setting up these Planner Premium automation flows for customers and it took a couple of days worth of work just to establish a PoC of updating tasks in Planner Premium plans.