Integrating Multiple Planner Boards into a Power BI Dashboard

Stay in the loop


planner powerbi integration

Thursday, May 20, 2021

12 - 1 PM EDT

Microsoft Planner is a planning application available within Microsoft 365. It is fantastic for assigning tasks and sub-tasks to users and has a lot of value in tracking progress for different initiatives. We use planner on both internal and consulting projects as it provides simplified task management. However, when you belong to multiple Planner boards, it can become challenging to manage tasks and get a holistic view of all tasks and their assignments in a single pane. 

We found this out quite quickly and turned to building a Power BI dashboard to provide us this view. Having a solution that allows for rolling up multiple planner boards into portfolios which can then be presented in a very visually appealing dashboard makes it much easier to be decisive and identify potential task conflicts. These portfolios can also be organized into different dashboards, so that security can be applied.

In this webinar we will cover: 

  • Business scenario
  • Technical challenges connecting Power BI to Planner - no existing connector
  • SharePoint lists to organize Plans into Portfolios, and Portfolios into Power BI reports to manage security
  • Leveraging Azure Automation in the cloud to collect and organize the Planner content 
  • Visualizing this through dashboards and reports in Power BI 
  • Publishing this out for the organization to consume


Peter Carson headshot

Peter Carson

Peter Carson, President of Extranet User Manager and a Microsoft MVP, is a recognized expert in Office 365, SharePoint, and Extranet strategies. Read Peter's full bio and check out some of EUM's recent articles and blogs for all things Microsoft and extranet related.