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

[AylaMendonca]

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]

Hi,

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

As triggers you have this options:

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:

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

[#3]

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 ?