How to connect to Microsoft Planner to Power BI

[smjzahid]

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.

[kmax]

Hi,
What I did was export the planner data into JSON files (buckets, users, assignements, tasks, labels) etc using automate flow.  Stored these JSON files on sharepoint site and connected through web connecter. Created model in Power BI and and the report was completed.

[Shreeom]

Can you pls provide me the template. As I tried doing in the similar way but all efforts gone waste.

[kmax]

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

[christinepayton]

Since this appears to be one of the top Google results for "get planner data", I just want to share that there's an update to this series that is much more clear to follow for the part 2 - the original link will no longer work (I unlisted it to avoid confusion), unsure if you're able to edit your post link @kmax ? Here's the new one:

Get All Planner Task Details with Power Automate

Thanks!!

[v-jingzhang]

Hi @smjzahid 

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. 

Other options: 

Visualizing Microsoft Planner & Tasks data in Power BI — DATA GOBLINS

Or third-party connector:

Author Power BI Reports on Real-Time Microsoft Planner Data (cdata.com)

Best Regards,
Community Support Team _ Jing

[Watsky]

Hey @smjzahid , I agree with @ImkeF. Out of curiosity, what happens if you try to use microsoft graph as an OData Feed? 

https://graph.microsoft.com/v1.0/planner/plans/{Plan ID}

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.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[LijunChen]

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?

[smjzahid]

Hi @Watsky 

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?

[Watsky]

The closest to grabing all tasks related to a plan and bucket is using 

https://graph.microsoft.com/v1.0/planner/plans/{plan id}/tasks

You probably want more specific info that's found in

https://graph.microsoft.com/v1.0/planner/tasks/{task id}/details

Within here you can find the Last ModifiedDateTime. Downside is this is done on the task level and not the planner level.

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[smjzahid]

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

[Watsky]

@smjzahid ,

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.

Graph Explorer - Microsoft Graph

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[smjzahid]

Hi @Watsky 

Thanks for your reply, I tried the Graph Explorer, but then it asks for an admin credentials. (see below). 

[Watsky]

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.

[ImkeF]

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.