Fix Power BI Showing SharePoint Person Fields as [List]
Question details
Users need to extract actual text values like names or emails from a SharePoint Person or Group column that appears as a nested [List] in Power BI.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Importing a SharePoint list containing a Person or Group column into Power BI for reporting and data visualization.
- Observed behavior
- The imported Person or Group column displays as [List] instead of showing the actual user details, because the field contains nested user records.
Ensure you have opened your dataset in Power BI Desktop and have successfully connected to your SharePoint list source before proceeding.
Expand the Nested Field in Power Query Editor
Use the built-in expand feature in Power Query to extract nested text values such as DisplayName or Email from the [List] column.
SharePoint Person and Group columns are complex data types that contain multiple attributes (e.g., name, email, department, claims). When imported into Power BI, they are naturally bundled into a [List] or [Record] to preserve all underlying data. You must manually declare which specific attributes you want to extract into standard text columns.
In Power BI Desktop, navigate to the Home ribbon and click on 'Transform Data' to launch the Power Query Editor.
Scroll horizontally through your dataset to find the specific SharePoint Person or Group column that is currently displaying the value [List].
Click the Expand icon (two diverging arrows) located in the top-right corner of the column header.
From the dropdown menu, choose 'Extract Values' if prompted, or simply check the boxes next to the specific properties you need, such as 'DisplayName', 'Email', or 'Claims', then click 'OK'.

Manage Exported SharePoint Data Easily with WPS Office
While Power BI is required for complex SharePoint list connections, WPS Office serves as a highly capable and free alternative to Microsoft Office for analyzing exported CSV or Excel datasets. Experience a lightweight spreadsheet tool with seamless format compatibility.
- 1. Download the Software: Visit the official WPS website and click 'Download WPS Office Free' to install the suite on your device.
- 2. Open Your Data: Launch WPS Spreadsheet and open your exported SharePoint CSV or Excel files directly.
- 3. Analyze and Format: Use built-in pivot tables, formulas, and formatting tools to easily manage your personnel lists and dataset.

Frequently Asked Questions
Why does Power BI show SharePoint columns as [List] or [Record]?
This happens because certain SharePoint columns, like Person, Group, or Lookup fields, contain multiple nested data attributes (such as name, email, and ID) rather than a single simple text value.
Can I extract multiple properties from the SharePoint Person field at once?
Yes. When you click the expand icon in the Power Query Editor, you can select multiple checkboxes (e.g., both DisplayName and Email) to create separate columns for each property simultaneously.
What should I do if my column shows [Table] instead of [List]?
The resolution is identical. Click the expand arrows in the column header within Power Query Editor to reveal the underlying columns of the nested table, then select the data fields you wish to display.




