- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Planner to Power BI issues
Hey Guys,
So I have problems connecting Planner to Power BI using Flow. (Planner => Excel => POWER BI)
The data I can connect between them is insufficient.
I've seen it before on this forum but I haven't found any possible solution online except for Third party tools.
Is there any way to to connect them automatically including all data from Planner? Any work arounds or something?
Thanks in advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @BramDeWinne ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. More people will benefit from here. Thanks in advance.
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.
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
08-01-2024 08:54 PM | |||
06-10-2024 01:20 PM | |||
07-08-2023 04:25 PM | |||
Anonymous
| 01-24-2020 06:29 AM | ||
07-17-2024 02:53 AM |
User | Count |
---|---|
115 | |
75 | |
45 | |
44 | |
32 |
User | Count |
---|---|
172 | |
90 | |
66 | |
46 | |
45 |