Expand Table field

[Craigja123]

Completly new to PowerBI so please be gentle!  I have a SharePoint List that Im using as my datasource.  This list has a Column - Team - which is a lookup to a set of Team Names in our department.  The person who has populated the list has then on some rows in the SharePoint list added more than one team in the Team column. So if I look at the list, I see 1 row and in the Team column, TeamA, TeamB and TeamC (for example)

When I open the List in PowerQuery I see this final column as Table and I assume that I somehow in PowerQuery need to expand the Team column (That shows as a Table) and get the individual Teams to allow them to be seen in the dataset.  How do I do this?

Also, if I click on any of the tables in PowerQuery I get the below error:DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (Specified method is not supported.) this is the screenshot below

[ppm1]

Quick tip - you can click in each cell to the right of the Table link to preview the contents of each below (don't click on it). Also, you can hit the double arrows at the top of the column to expand all the tables.

Pat