Skip to main content

46 posts tagged with "Power BI"

Microsoft Power BI Workspaces, Semantic Models, Reports, Row-Level Security and Refresh in the Power BI Service

View All Tags

How to Get the Email from a SharePoint Person Column in Power Query

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

A SharePoint Person column doesn't arrive in Power Query as a name or an email. In the SharePoint Online list connector's implementation 2.0, it shows as [List] or [Table]: a structured value with the person's id, name, email and more. Expanding it gives you a plain email column. Here's how, for a column that holds one person and for one that holds several.