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 severa...
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
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).