Table error in Power BI column

[Anonymous]

Hello All,

I have a SharePoint list which has over 10 columns.

One of the column is Escalated to whom?.

The cloumn type is person or group

Allow multiple selections: Yes.

That means user can select more than one name for this.

We have SharePoint Online. I connected to the PowerBI through the SharePoint list.

The issue is this: 

Escalated to whom? cloumn show as Table as you can see in the screenshot.

When clcik on the Table it gives me the following error:

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (Specified method is not supported.)

What I want to achive is this:

I want to list the selected names with comma under the Escalated to whom? cloumn rather than "Table".

I hope somone out there knows the sloution.

I would like to thank you in advanced.

Kind Regards

Power BI Query Editor screen:

SharePoint list editor screen

[Vera_33 · Accepted solution]

Hi @Anonymous 

Can you click on the space next to the Table to see the structure? If the table contains a column which has all the selected names, you can either transform current column or add a new column with the structure like this with add column as an example, but it still depends on your table structure

Table.AddColumn(yourPreviousStep, "Custom", each Text.Combine([Escalated to whom][theColumnContainsNames], ","))

[MCY]

Hi Dersim,

I met exactly the same issue for one list whether other lists in the same SP site works perfectly. After two days I've found a workaround by
1) graphical user interface : Get Data -> SharePoint Online list -> select option "Implementation 2.0" before entered your Site URL -> OK.
2) power query : = SharePoint.Tables("YOUR_SITE_URL", [Implementation="2.0", ViewMode="Default"])

Hope it will help 😉

[respinosa1962]

Was there ever any resolution to this?  I too need to have multiple selections allowed for my Business Owner field...I also submitted my issue on this forum.

[Vera_33]

Hi @respinosa1962 

Previously it was due to the version of Power BI Desktop for @Anonymous , if you don't have error casued by that, you can refer to the code to combine the text

[Anonymous · Accepted solution]

I tried everything and it did not work. I contacted to Microsoft for support. They told me we cannot help you until you installed the latest version of Power B1 and test it.

I downloded the latest version of Power BI and tested it. 

The problem disappereed.

Thnaks for everybody support on this.

[Vera_33 · Accepted solution]

Hi @Anonymous 

Can you click on the space next to the Table to see the structure? If the table contains a column which has all the selected names, you can either transform current column or add a new column with the structure like this with add column as an example, but it still depends on your table structure

Table.AddColumn(yourPreviousStep, "Custom", each Text.Combine([Escalated to whom][theColumnContainsNames], ","))

[Anonymous]

Hello @Vera_33 ,

Thanks for your answer.

When I click on the space next to Table, it gives the errror that shows on the screenshot below.

when I add your formula, it says: it does not recognise yourPreviousStep.

[Vera_33]

Hi @Anonymous 

The yourPreviousStep means your previous step, in the screenshot it indicates #"Removed Other Columns4" as your previous step. From the error, I can't see your table structure, can you try to delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

[Anonymous]

Thanks Vera_33, 

I have already tried that one too. It did not work.

[Vera_33]

Hi @Anonymous 

I can't replicate your issue, maybe you can try to raise a support ticket here:

https://powerbi.microsoft.com/en-us/support/

Someone in Microsoft will contact you

[Anonymous]

When I change the column type "Allow multiple selection" from "Yes" to "No" from the SharePoint list then it works fine. But I need this works with "Yes" as multiple selection. Because the filed will have several names, not only one.
Hope someone comes up with a sloution.