Need help expanding column with table data from Share Point.

[Anonymous]

Hello PowerBI gurus,

We have a sharepoint list to track projects. Every project has a team(team members are pulled from AD) and I have difficulty to expand this column in PowerBI.  I tried several ways and it gives me out error. Could any one help me with this ?Error from advanced editordrilldown errorNo columns were found when tried to expand from column

[Anonymous]

Hello, Is this sharepoint list merged into an existing query?

I think your joins may have an issue (most likely the type, either they are not all text or something like that).

[Anonymous]

It's one single list and I haven't used any joins while extracting the data. 

[Anonymous]

Hi @Anonymous,

Current power bi not support to expand records type, you need to manly do it though record function.(e.g. add custom column with record functions to extract specific fields values from record type column)

BTW, you can also take a look at following links:

Guy in a Cube - How to expand a list of records in a query

Record functions

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Sheng,

I tried those suggestions from "Guy in a cube" and had no luck. Probably I will explore record functions.  

[Anonymous · Accepted solution]

Hi @Anonymous,

If this is a case, you can consider to use 'Record.ReorderFields' function to choose fields which you wanted, then you can use table functions to transform filter fields to table format which power query can expanded.

Reference links:

Record.ReorderFields	Returns a new record that reorders fields relative to each other. Any fields not specified remain in their original locations. Requires two or more fields.
Record.SelectFields	Returns a new record that contains the fields selected from the input record. The original order of the fields is maintained.
Record.ToTable	Returns a table of records containing field names and values from an input record.

Regards,

Xiaoxin Sheng