Forum Discussion
Planner to Power BI issues
Hi BramDeWinne ,
Unfortunately, we still need to connect Planner to Power BI by third party tools, like Excel, SharePoint list and etc.. You could vote up the idea : Load data from Office 365 Planner to PowerBI to make Power BI better.
Here are some blogs about how to implement the requirement by SharePoint list. Maybe it will help you get all the data.
Use Flow to push the data from Planner into SharePoint lists
Microsoft Planner and Power BI - Better Together
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Thanks for the answer!
I already tried the things that you linked in the answer but it is not working out that great for me.
Guess I'll have to check out the third party tools and hope for a solution by Microsoft itself in time..
Kind regards!
BramDeWinne try using the graph api
https://docs.microsoft.com/en-us/graph/api/plannerplan-get?view=graph-rest-1.0&tabs=http
To get the data in PBI, I used a web datasource with the following URL
https://graph.microsoft.com/v1.0/planner/plans/{plannerid}/tasks