Dynamic Column Expand

[geirselvag]

Hi Folks,

I get error message when trying to dynamically expand columns.  When doing manuell column expand, the step is working but the content will change over time. The underlying data include record type, so there's a need to further expand these and unpivot the fields.

Would appreciate any tips and suggestion.

Thanks!
GS 

[jennratten]

Hello - without seeing a preview of the table it's hard to say for sure, but I would guess your table is returning some null records instead of list records, which cannot be expanded without first converting the values. Can you please confirm whether or not this is indeed the case?  At the RemovedColumns step, pls click the whitespace next to the first record object in the column (since in your screenshot it looks like that is one throwing an error).  Can you please post a snip of what you see in the preview when you do that?

[geirselvag]

@jennratten, thank you for you feedback. The underlying data, is nested records.



The structure after the 2nd underlying record (columns) is not dynamic - but has fixed columns (ref. Exp_Value, Exp_assingedBy, Exp_user). Therefore only looking for dynamically expand the first column ("assingments" - user id) with records, that also generate null values (ref. photo) because keep taskId reference.

The M Power Query, is working but based on manuall step by step configuration. The issue start when a new assignment is created, so that have to re-run the manual expand columns process.