I can see there is no out of the box ro direct connect available within PBI Desktop which connect to Microsoft Planner.
How can I connect to Planner (without using Microsoft Graph API) considering I am not the GLOBAL ADMIN on my Azure tenant.
How do I keep this data updated in Power BI 9meaning whnever someone modifies any bucket on panner, it should then be picked up in the next scheduled refresh in Power Bi and the report must then show the changed data.
Is there a easy way to do this, I have tried so many option but all in vein.
You need to export planner data in JSON using Power Automate.
Here is the step by step process to connect Power BI to planner data, modeling and build the report.
Part-1: https://www.youtube.com/watch?v=RbcrJbwoIOwChristine Payton - YouTube
Part-2: Get PLANNER Data into Power BI Part 2: Assignee Names & Bucket Names - YouTube
You may try some Power Automate solutions. There is a Power Automate Template (Export Microsoft Planner tasks to a SQL database). You can export Planner data into a database at a scheduled time and connect Power BI report to this database.
Or third-party connector:
Community Support Team _ Jing
I ask because I am not a Global Admin on my tenant but I don't have any problems loading this up. For credentials I used my org account.
HI @Watsky Your post is very helpful. I used the ODate feed and imported the data of a Plan to Power BI. However, I found the imported data has nested tables that cannot be openned and some fields such as notes and descriptions are missing in the data. As the bucket and tasks are two separate tables, I have to import them separately and merge them. Have you met with the these problems?
Yes If I use above URL as ODATA Feed connector in PBI, get some results back in Power BI (see below)
after clicking on the bucket (table) it then gives this navigation step, where it says below error,
How Do I fix this error in Power BI please?
The closest to grabing all tasks related to a plan and bucket is using
You probably want more specific info that's found in
Within here you can find the Last ModifiedDateTime. Downside is this is done on the task level and not the planner level.
Thanks for the above links, It does not give me detailed information on Plan level. How do I retrieve below shown columns from ODATA Feed or the WEB connector please
Unfortunately there isn't a one stop API call that will give you all of this. It will take using all of the different calls to gather this information.
Take a look at the Graph Explorer and search using the word planner.
Hey @smjzahid ,
You don't have to sign in just use the search below the sign in button and search planner. That will give you all the different calls you can make against it.
Hi @smjzahid ,
I'm not aware of a solution in PBI that doesn't use the Graph API.
What you could do is to set up a flow in Power Automate that retrieves all buckets regularly and and writes back changes to a file that PBI ingests.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries