Planner to BI

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

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/ba-p/448247

https://techcommunity.microsoft.com/t5/planner/looking-for-to-establish-planner-connection-with-powerbi/m-p/1505148

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-8211-part-2/ba-p/362279

https://techcommunity.microsoft.com/t5/planner-blog/microsoft-planner-considerations-for-reporting-part-3/ba-p/362297

Best Regards,

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

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