Forum Discussion
Exporting Planner Data with Power Automate & Visualizing in Power BI
Yes, your proposed setup is technically feasible and aligns well with Microsoft’s ecosystem. you can follow the below article to setup this flow.
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Import-Microsoft-Planner-Data-into-Power-BI-Using-Power-Automate/ba-p/4258773Yes 100% possible:) i once automated our Planner tasks to Power BI report by following tutorial videos from Christine Peyton. She`s such a good expert in Power Automate!
https://www.youtube.com/watch?v=q7bkWpVczz0
Hopefully this helps.
Thank you for your quick responses.
Would you also recommend PowerBI for 1.) creating my KPIs and 2.) visualize them in a dashboard?
No problem! by recommending Power BI for these two works did you mean if Power BI would be a better tool than others in visualizing them? or?
Yes, I was mainly asking whether Power BI is the best-suited tool for
creating KPIs based on Planner (or similar) data, and
visualizing them effectively in a dashboard — especially compared to other tools like Excel, Tableau, etc.
If you have any insights or recommendations based on your experience, I’d really appreciate it!
I'd say the fair answer would be it depends on your organization. I personally use Power BI all the time because this is required where i work. In terms of performance, there are pros and cons for each tool, but both do the jobs 🙂