Microsoft Planner is a widely used tool for team task management. However, its built-in analytics capabilities can be limited when deeper tracking of progress, performance, and task completion is required. In this context, Power BI can serve as a complementary tool to create custom dashboards with key indicators, efficiency metrics, and interactive visualizations. 

Among the functionalities that Power BI enables are time-based analyses, such as metrics that reveal how many days a task remains open, the average completion time, the duration of each phase in a workflow, and the identification of bottlenecks that delay projects. It also facilitates tracking task status, assignments, workloads, response times, and overall company performance, with the added flexibility of incorporating custom KPIs. 

To achieve this integration, Dataverse acts as the bridge between Planner and Power BI. 

The Role of Dataverse in This Integration 

Planner does not expose its data directly in a traditional database that Power BI can easily access. However, through Dataverse, Microsoft’s cloud-based relational data platform, this information can be accessed in a structured format. Features like Planner Premium or Project for the Web already store their data in Dataverse, making it easier to analyze with Power BI. 

Basic Platform Architecture 

A data analysis platform based on Microsoft Planner, Power BI, and Dataverse typically includes the following components: 

• Microsoft Planner: Creates and manages team plans and tasks. 

• Dataverse: Collects and structures task and plan data from Planner. 

• Power BI: Connects to Dataverse to query, visualize, and analyze the data. 

The architecture diagram would look as follows: 

Integration Steps 

1. Confirm Data Availability in Dataverse 
   1. Access Power Apps.
   2. Select the appropriate environment.
   3. Review available tables such as msdyn_projecttask, msdyn_projecttasktolabel, or msdyn_resourceassignment. 
2. Connect Power BI to Dataverse 
   1. Open Power BI Desktop. 
   2. Select Get Data and then choose the Dataverse option. 
   3. Sign in with your Microsoft 365 account and select the tables that contain the relevant information (e.g., tasks, users, statuses, dates). 
3. Create Relationships and Models 

It’s important to establish relationships between the imported entities, such as tasks, plans, and users. 

You can then create useful metrics or KPIs, such as: 

• Tasks per user 

• Percentage of tasks completed 

• Delays in due dates 

4. Publish and Share the Dashboard 

Technical Considerations 

Licensing: You need appropriate licenses to access Dataverse (e.g., Power Apps, Project Plan 1/3, or Microsoft 365 Premium). 

Security: Data in Dataverse complies with Microsoft’s security policies. Additionally, access can be restricted based on roles and defined permissions.