Planner to power bi

GMkk — Tue, 16 Jul 2024 10:30:19 GMT

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.

Re: Planner to power bi

Anonymous — Wed, 17 Jul 2024 07:46:37 GMT

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 data from Planner, writes it to Excel, which is then visualised in Power BI

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.

topic Re: Planner to power bi in Report Server

Planner to power bi

Re: Planner to power bi