Forum Discussion

JOSE ANGEL HINOJOSA's avatar
JOSE ANGEL HINOJOSA
Copper Contributor
Jan 10, 2018

How to automate Planner and integrate it with Power Bi

Lets say on my work i have to do the same exact activities, one after another and my boss wants to assign those tasks to my team through Microsoft Teams, how can i make like a sample tasks that i just change the name but the check list is the same and that those tasks are linked one after another.

Besides that I want to know if its possible to graph how much time it takes me to complete those tasks using Power Bi or any other application from Office 365. 

 

Thanks for your time and help.

18 Replies

  • Eric Eaton's avatar
    Eric Eaton
    Iron Contributor

    I agree about using Flow to export data to SharePoint lists. I find that helpful for SCRUM teams that want to use Planner. There are some frustrations with that though, as not all the Planner fields are available to Flow (specifically, the multi-value fields like labels and checklist). If those aren't important to you, then that'll do fine. I'm curious how you'd measure the duration of a Planner task. In many cases, I find that tasks are created / staged well in advance of when they're going to be worked on. Would you try to look at the Planner 'created'  value, or would you push things to SharePoint frequently as they're moved to 'In Progress' and then look at the SharePoint created date? Just thinking out loud - I don't have a well thought out recommendation for this.

     

    Here's an answer for the 'clone tasks' part of your question. You can do use the 'copy task' menu command for this. Either copy a completed task or setup some dummy tasks with generic names in a separate bucket. Then move the copies to whatever bucket you want for tracking.

     

    • francisliu's avatar
      francisliu
      Copper Contributor

      Eric Eaton 

      I'd have a backlog column, where tasks can be created/pre-loaded.

      Then, each sprint, move items from the backlog into a "to-do" column. You'd also have the typical doing", and "done" columns.

       

      With that in place:

      I'd have a metric for "days-in-backlog", which would be calculated as days from "created in backlog", until column change.

      I'd have another metric for cycle-time, which would be the date that the item entered the "to-do" column until it moved to the "done" column.

  • I would like to have access to planner data's from within PowerBI.
    Indeed, I would like to manage my teams achievements, risks and issues on a regular basis, in order to promote the tasks we fulfill.
    • SanthoshB1's avatar
      SanthoshB1
      Bronze Contributor
      You need to export the Planner data to SharePoint or OneDrive so you can establish it with PowerBI dashboard. However there is no direct way as of now, you need to depend on third party apps for now, to export the Planner data to Excel in regular intervals so the PowerBI dashboard will be automatically refreshed.
  • Planner does not provide the ability to link Tasks as you can do with Project online and at the moment there is not way to obtain how much time is taking to complete a task

Resources