How to connect Teams - task by planner and to do with powerbi

[LuanMarques]

Hi,

I need some help to connect task by planner and to do with powerbi by team teams. I foud some videos and tutorial about planner but not with teams task by planner and to do.

Thank you.

[rohit1991]

To connect "Tasks by Planner and To Do" with Power BI in Teams:

1. Extract Task Data:

   • Use Power Automate to fetch tasks from Planner (via "List Tasks" action) and store them in Excel, SharePoint, or a database.
   • Alternatively, use Microsoft Graph API (/me/planner/tasks) to query task data and save it in a Power BI-compatible format.

2. Connect Power BI:

   • In Power BI Desktop, import data from SharePoint, Excel, or the database where task data is stored.

3. Create Dashboards:

   • Visualize task details (status, due dates, assigned users) in Power BI.

4. Embed in Teams:

   • Publish the Power BI report, then add it as a tab in Teams for easy access.

[Akash_Varuna]

I think you could do that by 
Firstly calling the API From micrososft for planner i think that would be somewhere in Azure i suppose through REST or GraphOne
After calling you could connect PowerBI with Web Connector