Forum Discussion
Need help expanding column with table data from Share Point.
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
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
5 Replies
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
Regards,
Xiaoxin Sheng