How to connect to Microsoft Planner from Power BI

[smjzahid]

Hi 

I would like to create a report in Power BI which pulls in data from Microsoft Planner. I can see there is no direct connector available as of today which does this. How do I bring in the entire data from specifc BUCKETS and visualise this using Power BI.

I wan to pull different fields from planner (see below snip)

Note: I have the role of Power BI Service Administrator assigned to me. I am not a global admin

[ChrisMendoza · Accepted solution]

@smjzahid -

I would guess you don't have access to Graph API https://docs.microsoft.com/en-us/graph/api/resources/planner-overview?view=graph-rest-1.0#visualizat...? That would be my initial thought on how to access the data.

Quite a few people will use Power Automate to CREATE items in a SharePoint List (or other) to use as the data source. Since you likely have existing data in Planner you would need to 'GET' the task items from each Plan. That will be fine for the already completed tasks but you'll also likely want to have the inprogress events updated in your SP List so you'll need to write a Power Automate to trigger on 'Task Complete' to update the record.

I outlined the 'GET' portion at https://powerusers.microsoft.com/t5/General-Power-Automate/Send-a-daily-email-of-incomplete-Planner-... and the 'Task Complete' is pretty straightforward as what is returned is the 'TaskID' so you can filter your datasource to update the record.

[Syndicate_Admin]

Hello

Thank you very much for the answer, I wanted to take advantage of consulting, I am using graph to bring the tasks of planner but only brings 400 records when in my planner I have more than 700. How can this be resolved?

I used the parameter $count=true but it still brings me 400 records.

Best regards

[ChrisMendoza]

@Syndicate_Admin @agarridov - unfortunately my tenant does not allow me access to MS Graph so I can not actually test. Maybe try posting your question in Welcome to the Microsoft Graph group.