How to connect to & model premium "Planner for the Web" data in Power BI or Excel
This is a deep dive into getting premium Planner data using Power BI and Power Query in Excel. I’ve added chapters below to help you jump to the parts you need, because it is very long! The data we are getting here is for the app formerly known as Project for the Web.
🛠️ RESOURCES
Color labels in Planner data: https://christine-payton.com/microsof...
Vote to have the Planner custom fields added to the Dataverse data here: https://feedbackportal.microsoft.com/...
▶️ RELATED VIDEOS
Get Planner data for NON-Premium Planner: • Get Planner Task Details with Power A...
How to migrate plans and tasks to Premium Planner: • How to import tasks from basic Planne...
Ping Planner assignees in Teams or Outlook from Power BI with a button: • Use the Power Automate visual in Powe...
Free Gantt with milestones, dependencies, phases in Power BI: • Timeline Zoom & Planner Data in David...
Microsoft's Gantt chart visual in Power BI: • How to create a Gantt chart in Power ...
⏲️ TIMESTAMPS
0:00 Intro
1:23 Connect to Planner data - Excel
2:01 Connect to Planner data - Power BI
7:51 Turn off auto-relationships
9:14 Projects table
11:17 Hyperlink to project
12:18 Tasks table
12:30 Note about data access/permission-trimming
17:06 Add task status
19:26 Add task priority text
20:42 Query folding in Dataverse
21:28 Add overdue yes/no
22:42 Hyperlink to Task
24:21 Assignees table
25:28 Labels table
28:07 Fix for “may not directly access a data source”
30:05 Project team table
30:56 Users table
31:58 Create relationships
34:45 Sort by other column
38:36 Comma-separate assignees
35:09 Create DAX measures
40:31 Visualize
42:02 Clickable hyperlinks
42:22 Identifying bottom-level tasks
🪽 CONNECT WITH ME
Blog: https://christine-payton.com/
LinkedIn: / christinehpayton
🎁 SUPPORT THIS CHANNEL
Shop: https://shop.bi-ome.com/
#planner #dataverse #powerquery #taskmanagement #msproject #m365
Смотрите видео How to connect to & model premium "Planner for the Web" data in Power BI or Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Christine Payton 24 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,356 раз и оно понравилось 29 людям.