How to display Microsoft Planner tasks from multiple team members?

Question

How to display Microsoft Planner tasks from multiple team members?

Rettenmeier, Emily 0

Does someone know how to display Microsoft Planner tasks from multiple team members in a Power BI report?

(Mircrosoft Graph Explorer not allowed)

0 comments

1 answer

Your answer

Answer 1

Jayden-P 2,440 Independent Advisor

Hi @Rettenmeier, Emily

Power BI does not currently provide a native connector for standard Microsoft Planner task data. A common approach is to use Power Automate and SharePoint as an intermediary to make Planner tasks available for reporting in Power BI.

This approach allows you to report on tasks across multiple team members and Planner plans without using Microsoft Graph Explorer. The solution outlined in the Microsoft Fabric Community article uses Power Automate to extract Planner tasks and save them as a JSON file in SharePoint, which Power BI then consumes and transforms into a reporting dataset. Once loaded into Power BI, you can build reports based on task assignees, status, due dates, buckets, and other Planner attributes.

Ref: https://community.fabric.microsoft.com/blog/community_blog/import-microsoft-planner-data-into-power-bi-using-power-automate-and-sharepoint/4258773

Additionally, Power BI is not currently supported in the Q&A forum. If you'd like more accurate and in-depth guidance on Power BI scenarios, I encourage you to post a question to the official Microsoft Power BI forum. In that community, subject matter experts and product experts can provide additional support.

I hope this helps.

Rettenmeier, Emily 0 Reputation points

2026-08-31T12:00:49.53+00:00

Thanks for your fast response! But is with that solution live tracking possible? (or eg. catch every day the new data and display it in Power BI)
Jayden-P 2,440 Reputation points Independent Advisor

2026-08-31T12:15:14.44+00:00

Yes, but it would not be truly real-time.

In the approach described in the article, Power Automate periodically exports Planner task data to a JSON file stored in SharePoint, and Power BI reads that JSON file as its data source. As a result, the report is only as current as how often the Power Automate flow runs to refresh the JSON file.

For example, you could configure the flow to run daily (or more frequently, depending on your requirements and licensing) so that new and updated Planner tasks are written to the JSON file automatically.

Therefore, daily tracking of new tasks and updates is possible with this solution, but it should be considered scheduled refresh reporting rather than live tracking
Jayden-P 2,440 Reputation points Independent Advisor

2026-09-01T11:09:31.3133333+00:00

Any update from you? Do you need anything else?