Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to Solution.
Hi @BOBBY21,
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).
It's one single list and I haven't used any joins while extracting the data.
Hi @BOBBY21,
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
Hi Sheng,
I tried those suggestions from "Guy in a cube" and had no luck. Probably I will explore record functions.
Hi @BOBBY21,
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |