Accessing Assignments from Planner graph in power bi

[testcoder]

Hi,

I would like to create a table that has tasks - assignee ID from using the graph API in power query.  The current layout does not allow me to do this.  The assignments column is a record with sub records.

Thanks

[Anonymous · Accepted solution]

Hi @testcoder ,

For records in Power Query, you can expand them.

You can use the Table.ExpandRecordColumn function in Power Query to expand the assignments column into separate columns for each sub-record. Then, you can select the tasks and assignee ID columns to create a new table with the desired layout.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.