Planner to power bi

[GMkk]

Hi, for the first time our organization is trying to show the planner tasks/ items in power bi.

My line manager had 3 departments under him, how can i show all the 3 departments plans in one power bi report,
how to automatically update the dataset for the planner, is there a way to connect all departments plans at once?
do i need to create any power automate flows, so that every night the data gets updated and it then updates dataset on sql server? 
please suggest me with the best options for me to do
Thanks for taking your time to read this, i appreciate everyone for their suggetsions.

[v-jianpeng-msft · Accepted solution]

Hi, @GMkk 

Unfortunately, there is no direct off-the-shelf connector between Power BI Desktop and Microsoft Planner.
You can refer to these documents below to merge your Planner into Power BI.

GitHub - ben-howard/Planner-PowerBI-with-PowerAutomate: Contains a PowerAutomate file that takes dat...

How to automate Planner and integrate it with Power Bi - Microsoft Community Hub

How to connect to Microsoft Planner to Power BI - Microsoft Fabric Community

Best Regards

Jianpeng Li

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