Solved: Rest API with empty Record

Anonymous · ‎12-17-2018

Im Newer in PBI

I would like to connect to Rest API thas done , but i have this problem

when i would like to expand the column i dont have the ICON ?

i learn the basics on Language M and i m still struggling to find the solution how can i get value of the this records .?

I have 5 column ho i have column like Image !!

Thank you in advance

Anonymous · ‎12-17-2018

@Anonymous,
You would need to add a step in Advanced Editor to check if the type of the value is record and then expand the record.

There is an example for your reference:

let
    Source = Table.Combine({jsontest, Table4}),
    expand1=Table.TransformColumns(Source, {{"Value", each if Value.Is(_, type record) then _ else [a=_] }} ),
    #"Expanded Value" = Table.ExpandRecordColumn(expand1, "Value", {"name", "age", "maritalStatus"}, {"Value.name", "Value.age", "Value.maritalStatus"})
in
    #"Expanded Value"

Reference:
https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...

Regards,
Lydia

View solution in original post

Anonymous · ‎12-17-2018

@Anonymous,
You would need to add a step in Advanced Editor to check if the type of the value is record and then expand the record.

There is an example for your reference:

let
    Source = Table.Combine({jsontest, Table4}),
    expand1=Table.TransformColumns(Source, {{"Value", each if Value.Is(_, type record) then _ else [a=_] }} ),
    #"Expanded Value" = Table.ExpandRecordColumn(expand1, "Value", {"name", "age", "maritalStatus"}, {"Value.name", "Value.age", "Value.maritalStatus"})
in
    #"Expanded Value"

Reference:
https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...

Regards,
Lydia