Forum Discussion
Table error in Power BI column
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
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], ","))
10 Replies
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 😉
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], ","))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.
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
