Forum Discussion
Report Template for Planner
Hi David_G-R ,
Planner does not offer a direct indicator for premium or basic plans. However, you can differentiate between them by examining the schema: premium plans include fields such as Effort or are represented as projectTask in Graph/Dataverse, whereas basic plans do not have these features.
In Power BI, you can add a calculated column :
PlanType = IF(ISBLANK([Effort]), "Basic", "Premium")
Thank you for your quick reply.
I thought that might be the case. The main issue I have is there are many tables that made up the P4W app, so it will take a while to understand which fields are included in the basic plans. I'm just confused why there is a value in a basic task for effort, how is it calculated? There are several assiginees but the same effort across everyone......and what calendar is in use?
A little bit more research required.
Hi David_G-R ,
The Effort field you’re seeing is not generated by Planner itself, as Planner does not have an effort field. Instead, when Planner tasks are processed through Dataverse/Graph, they are mapped to the legacy Project for the Web schema, which always includes an Effort field.
For basic Planner plans, this Effort value serves only as a placeholder - it is duplicated for all assignees and does not represent actual workload.
The system assumes the default Project calendar (Mon–Fri, 8h/day), even though Planner does not utilize calendars.