Get PLANNER Data into Power BI with a 2-ACTION Power Automate Flow!

This is the quick-and-easy approach to pulling Planner data with Power Automate. It doesn't get task details, though, so if you need those please see the related videos for a more elaborate process!

Here's the custom Power Query formula we used to flag late items in the video (Github link, YouTube does not allow some of the code characters in the description):
https://github.com/chpayton/BI-Files/...

⏲️ TIMESTAMPS
0:00 Intro
0:43 Create the Power Automate flow
2:44 Enable overwriting on "create file"
3:39 Copy the file path & download
4:45 Connect in Power BI
6:35 Clean up the data
7:05 Add a custom column to flag late tasks
8:20 Schedule refresh

▶️RELATED VIDEOS
How to model and visualize the Planner data:    • Report on Planner Data in Power BI  
Get task detail data from Planner:    • Get Planner Task Details with Power A...  
Get Planner data for ALL your groups and plans:    • Get Planner Data for ALL your Plans i...  
Get Planner data for SPECIFIC plans:    • Get Planner data for a LIST of Plans ...  
Ping Planner assignees in Teams or Outlook from Power BI:    • Use the Power Automate visual in Powe...  
Power Automate Playlist:    • 🪼Power Automate  
Project & task data playlist:    • ✔️Get & Visualize Project & Task Data  

🪽 CONNECT WITH ME
Blog: https://christine-payton.com/
LinkedIn:   / christinehpayton  

🎁 SUPPORT THIS CHANNEL
Shop: https://shop.bi-ome.com/

#automation #projectmanagement #taskmanagement #powerautomate #planner