SharePoint List Data in Power BI (see pinned comment!)

This is a detailed tutorial covering how to deal with multi-value fields, creating hyperlinks directly to SharePoint item records, calculating whether items are overdue, and more.

Here is the concatenation formula we used in a calculated column the table: Stakeholder Names = CALCULATE(CONCATENATEX(Stakeholders, Stakeholders[Stakeholder Name], ", "))

If you're using the SharePoint list to manage requests, you may like this article that goes into detail on the topic: https://christine-payton.com/request-...

⏲️ TIMESTAMPS
0:28 Why SharePoint
3:30 Connecting to the list data
5:00 Cleaning the data
6:34 Getting people profile data
8:45 Dealing with multi-value fields
10:51 Hyperlinking to the SP item record
15:16 Relating our multi-value dimension
15:52 Creating visuals
16:49 Changing the date format
17:31 Configuring the item hyperlink
18:30 More visuals
19:38 Custom-sorting text axis labels
22:55 Date table
24:26 Creating a button to link to the "new item" form in SP
26:46 Calculating the "overdue" record count

🛠️ RESOURCES
Blog article on the v2 vs v1 SharePoint Online List connector: https://christine-payton.com/sharepoi...

▶️ RELATED VIDEOS
UPDATED version of this video here:    • How to use Microsoft Lists in Power B...  
Create a task list in Microsoft Lists:    • Build your own Task Board or Tracker!  
How to create a SharePoint list to act as a form:    • How to Make a Form in SharePoint  
How to embed a Power BI report in SharePoint:    • Embed Power BI Visuals or Pages in Sh...  

CONNECT WITH ME
📣 Get new videos via email! - https://bi-ome.kit.com/youtube
📝 Blog - https://christine-payton.com/
🔗 LinkedIn -   / christinehpayton  

💬 Questions? Drop them in the comments! Your question could help others too.