[Planner Cloud] Premium Plan - API capabilities

Question

Hello,
we are using within Planner cloud Premium plan (not Basic plan) for our plans. And we would like to be able to source the data from plans (e.g.: tasks,..) through API endpoints.

Planner API in Microsoft Graph ( https://learn.microsoft.com/en-us/graph/api/resources/planner-overview?view=graph-rest-1.0 ) is working well to source the data from Basic plans. But is there some other API endpoint, which could be used to source the data from Premium plan ?

And if there is not API, are there some other options (or workarounds), how to source the data from Premium Plan plans ?

I also understand, that Premium Plans data are stored in Dataverse within my Azure tenant. So, would it make sense to query the data from Dataverse through Tabular Data Stream (TDS) endpoint ? Is structure of tables in Dataverse for Planner fragmented ?

thanks

Answer 1

Hello Stanislav. Currently, task-related Microsoft Graph API endpoints will not work with Microsoft Planner Premium plans, as they work with their own Plan ID structure. This limitation is further confirmed in the Microsoft Q&A above. Even though the Premium plan offers additional features like goals, sprint functions, and task history, their data is all held in Dataverse and not in the structure you would expect to see with the Basic Planner plan.

To obtain data from a Premium plan programmatically, Microsoft wants developers to utilize Dataverse query options such as:

TDS (Tabular Data Stream) endpoint for SQL-like access

Dataverse Web API for RESTful queries

However, Planner Premium's Dataverse schema is disjointed and not publically documented for users, making it difficult to query directly. Alternatively, as a workaround you could use Power Platform connectors (e.g., Power Automate or Power BI) to engage or visualize Planner Premium data if you have the proper access and licensing permissions.

Best regards,