Report on Planner Data in Power BI
This video tutorial demonstrates how to connect and model Microsoft Planner data in Power BI. The tutorial covers splitting assignees, subtasks, and color flags into dimensions for filtering, displaying subtasks in a table visual with status icons, and scheduling data refresh. It also provides additional tutorials on automating the export of Planner data with Power Automate, scheduling refresh on datasets, retrieving Planner data for all groups and plans, sending notifications to assignees from Power BI, and using task data in the Microsoft Gantt chart visual. The video includes timestamps for specific steps, such as getting the JSON file/path, connecting to the file, transforming the data in Power Query, modeling the data, and visualizing the tasks.
Video 14m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time