Forum Discussion
Exporting Planner Data with Power Automate & Visualizing in Power BI
Hi everyone,
I’m currently working on an internal project and looking into how KPIs based on MS Planner data can be created and visualized.
My idea is to automate the export of Planner data (e.g. to Excel or a SharePoint list) using Power Automate, and then process and visualize it in Power BI.
Before I proceed, I’d like to ask:
👉 Is this setup technically feasible?
👉 Are there any known challenges (e.g. permissions, data access limitations)?
👉 Any best practices or tools you’d recommend?
Thanks in advance for any insights!
Best regards,
Adrian
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.
8 Replies
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!
