cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid
Helper V
Helper V

How to connect to Microsoft Planner to Power BI

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.

9 REPLIES 9
v-jingzhang
Community Support
Community Support

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
Super User
Super User

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.


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.

Proud to be a Super User!

Hi @Watsky 

 

Yes If I use above URL as ODATA Feed connector in PBI, get some results back in Power BI (see below)

 

 

image.png

 

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?

smjzahid_0-1632925171584.png

 

 

 

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

 

 

Watsky_0-1633016774803.png

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.

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.

Proud to be a Super User!

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

 

image.png

@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.


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.

Proud to be a Super User!

Hi @Watsky 

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

 

image.png

 

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.

 

Watsky_0-1633700421191.png


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.

Proud to be a Super User!

ImkeF
Super User
Super User

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.