Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Sheng,

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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