Others

Fix Power BI Showing SharePoint Person Fields as [List]

John WilsonJohn Wilson Nov 4, 2026 869 views

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.
Before you start

Ensure you have opened your dataset in Power BI Desktop and have successfully connected to your SharePoint list source before proceeding.

Solution 1Recommended

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.

1
Open Power Query Editor

In Power BI Desktop, navigate to the Home ribbon and click on 'Transform Data' to launch the Power Query Editor.

2
Locate the Target Column

Scroll horizontally through your dataset to find the specific SharePoint Person or Group column that is currently displaying the value [List].

3
Expand the Column

Click the Expand icon (two diverging arrows) located in the top-right corner of the column header.

4
Select Required Properties

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'.

Expand the Nested Field in Power Query Editor
Missing Expand Option: If the field cannot be expanded as expected, there may be an issue with the SharePoint connector version. Review your connector output or seek assistance in the Microsoft Tech Community forums.
Free Microsoft Office alternative

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. 1. Download the Software: Visit the official WPS website and click 'Download WPS Office Free' to install the suite on your device.
  2. 2. Open Your Data: Launch WPS Spreadsheet and open your exported SharePoint CSV or Excel files directly.
  3. 3. Analyze and Format: Use built-in pivot tables, formulas, and formatting tools to easily manage your personnel lists and dataset.
Fully compatible with Microsoft Excel (.xlsx) and CSV formatsLightweight spreadsheet application that runs smoothly on standard devicesFamiliar user interface requiring zero learning curve for Excel usersFree to use for everyday document creation and data analysis
microsoft office alternative - wps office

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.