Planner and Power BI Portfolio Management

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 place.

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 session 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
  • Real world client case studies

This session can either be delivered as a 45 minute to 1:15 breakout session in lecture style, or as a much deeper three-hour workshop format with opportunity for hands-on exercises and tools. In both cases the open-source tools and documentation are provided through GitHub.

Recent Events

Microsoft 365 Conference

Microsoft 365 Conference

Apr 5, 2022 - Apr 7, 2022

The Extranet User Manager team is heading to Las Vegas, NV for the Microsoft 365 Conference. President Peter Carson will be delivering a session on Teams and Microsoft 365 External Users - Unstructured and Structured at the conference.
365 EduCon (by SPFest)

365 EduCon (by SPFest)

Dec 14, 2021 - Dec 16, 2021

The Extranet User Manager team is heading to Washington, DC for 365 EduCon DC (by SPFest). This conference brings together experts in Microsoft 365, SharePoint, Office 365, Microsoft Teams, and Azure.
Managing Complex Projects with Microsoft 365

Managing Complex Projects with Microsoft 365

Jun 8, 2021
|   12–1 PM
Using a combination of tools within the Microsoft 365 suite, you can empower your users to manage their projects efficiently from start to finish with little to no reliance on IT.
Integrating Multiple Planner Boards into a Power BI Dashboard

Integrating Multiple Planner Boards into a Power BI Dashboard

May 20, 2021
|   12–1 PM
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.