Expand a table of persons field from SharePoint for Power BI

[Anonymous]

I have a column from a SharePoint list that is a persons field with multiple selections allowed that when I try to add to Power BI shows as a table. My problem is that when I try to expand the table it tells me that there are no columns and if I click on one of the I get the attached error.   Any help would be appreciated.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is your persons field with multiple selections like "MutipleValues" field below?

If so, please check the useful references:

How-to-display-an-assigned-user-in-a-sharepoint-list-in-Power-BI

Using Power BI to Report on Person Fields in SharePoint

https://whitepages.unlimitedviz.com/2016/07/simplified-method-working-sharepoint-data-power-bi/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AJ732101]

I have the same issue and in the solution section there is no real solution for this problem (only additional links where no solution for this certain issue is found).

A normal multiselection can be decomposed very easily.

This is also true for a single select column of type person.

This is not true for a mulitiple select column of type person. 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please let me know.

Best Regards

Maggie

[Anonymous]

OK, I was wrong the answer was in there just buried a bit.

[Anonymous]

Sorry but this did not solve my problem, I have multiple people selected.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Is your persons field with multiple selections like "MutipleValues" field below?

If so, please check the useful references:

How-to-display-an-assigned-user-in-a-sharepoint-list-in-Power-BI

Using Power BI to Report on Person Fields in SharePoint

https://whitepages.unlimitedviz.com/2016/07/simplified-method-working-sharepoint-data-power-bi/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.