Planner to BI

[jcastr02]

Is there a way to connect directly to a plan in Planner.  I'd like to be able to set on autorefresh and create my own reporting in BI with the data in Planner.

[eelernest]

You still have doubts how to do it? I connected it to Excel and it is automated without using flows...

[Anonymous]

Do you have a link to this process? 
I have Power BI online from office 365 for government and will soon have the desktop version but we do NOT have Power Automate. 

[Anonymous]

@jcastr02 

Power bi currently has no direct connector to connect with Power bi, here is an alternative method:

You can use Microsoft Flow to achieve this. Use Flow to push data from Planner to a SharePoint list (one for planning, one for boards, and another for tasks)-then create a report in the connection to the data source via Power BI

This is a link to related content, hope it will help you:

https://techcommunity.microsoft.com/t5/project-support-blog/where-did-that-old-msdn-technet-post-go/...

https://techcommunity.microsoft.com/t5/planner/looking-for-to-establish-planner-connection-with-powe...

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-8...

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-p...

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jcastr02 , refer if these two can help

https://community.powerbi.com/t5/Desktop/Power-BI-with-Planner/td-p/947232

https://community.powerbi.com/t5/Desktop/Planner-365-and-Power-BI-desktop/td-p/1032344