How to integrate Power Bi and Ms Planner using Ms Flow?

%3CLINGO-SUB%20id%3D%22lingo-sub-352082%22%20slang%3D%22en-US%22%3EHow%20to%20integrate%20Power%20Bi%20and%20Ms%20Planner%20using%20Ms%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352082%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERecently%20I%20faced%20an%20issue%3A%20how%20to%20get%20better%20reportings%20come%20from%20Ms%20Planner%3F%20And%20during%20my%20research%2C%20I%20read%20some%20discussions%20about%20using%20Ms%20Flow%20to%20export%20data%20from%20Planner%20to%20Sharepoint%20and%20them%20use%20Sharepoint%20data%20to%20build%20reportings%20in%20Power%20BI.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20someone%20have%20already%20worked%20with%20this%20idea%2C%20and%20if%20could%20share%20your%20experience%20about%20that.%20Basically%2C%20I%20woul%20like%20to%20re-ignite%20this%20dicussion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352082%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPlanner%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352408%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20integrate%20Power%20Bi%20and%20Ms%20Planner%20using%20Ms%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352408%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%20on%20which%20information%20and%20when%20you%20want%20to%20extract%20it%20from%20Planner.%3C%2FP%3E%3CP%3EAs%20triggers%20you%20have%20this%20options%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83449iC950AB0FE2A1A97C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22flow1.JPG%22%20title%3D%22flow1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20you%20can%20also%20work%20with%20time-triggers%20or%20other%20triggers.%3C%2FP%3E%3CP%3EBut%20then%20you%20need%20to%20be%20very%20specific%20about%20the%20tasks%20you%20want%20to%20extract%20with%20flow(if%20you%20could%20filter%20it%20on%20a%20specific%20intervall%20or%20something).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20have%20your%20trigger%2C%20you%20could%20extract%20data%20and%20create%20an%20entry%20in%20a%20Sharepointlist%20for%20example%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83450i99E50B84AA66EDEE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Sk%C3%A4rmklipp.JPG%22%20title%3D%22Sk%C3%A4rmklipp.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20it%C2%B4s%20possible%2C%20you%20just%20need%20to%20find%20the%20trigger%20you%20need%20and%20so%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880460%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20integrate%20Power%20Bi%20and%20Ms%20Planner%20using%20Ms%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880460%22%20slang%3D%22en-US%22%3EI%20am%20looking%20at%20the%20same%20issue%20for%20a%20customer.%20They%20have%20too%20many%20tasks%20and%20loose%20the%20overview.%20We%20want%20to%20use%20power%20BI%20to%20create%20custom%20reports.%20Any%20progress%20on%20this%20%3F%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

Hi Guys,

 

Recently I faced an issue: how to get better reportings come from Ms Planner? And during my research, I read some discussions about using Ms Flow to export data from Planner to Sharepoint and them use Sharepoint data to build reportings in Power BI. 

 

I would like to know if someone have already worked with this idea, and if could share your experience about that. Basically, I woul like to re-ignite this dicussion.

 

Thanks. 

2 Replies
Highlighted

Hi,

 

It depends on which information and when you want to extract it from Planner.

As triggers you have this options:

flow1.JPG

 

But you can also work with time-triggers or other triggers.

But then you need to be very specific about the tasks you want to extract with flow(if you could filter it on a specific intervall or something).

 

When you have your trigger, you could extract data and create an entry in a Sharepointlist for example:

Skärmklipp.JPG

 

So it´s possible, you just need to find the trigger you need and so on.

Highlighted
I am looking at the same issue for a customer. They have too many tasks and loose the overview. We want to use power BI to create custom reports. Any progress on this ?