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

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

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.

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 ?