Forum Discussion

Jayendran's avatar
Jayendran
Icon for Solution Sage rankSolution Sage
7 years ago
Solved

Convert json List Record to Table value

Hi,   I'm totally new to Power BI so I'm tried different approached to convert my JSON file to a table but unsuccessful so far.   This is my JSON File     { "Family": [ { ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Jayendran 

     

    You can use this

     

    let
    Source = Json.Document(File.Contents("C:\Users\hp\Desktop\File.JSON")),
    Family = Source[Family],
    #"Converted to Table" = Table.FromList(Family, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Father", "Age", "Mother", "MAge", "Children"}, {"Father", "Age", "Mother", "MAge", "Children"})
in
    #"Expanded Column1"

     

    Please see attached files as well

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Jayendran 

 

You can use this

 

let
    Source = Json.Document(File.Contents("C:\Users\hp\Desktop\File.JSON")),
    Family = Source[Family],
    #"Converted to Table" = Table.FromList(Family, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Father", "Age", "Mother", "MAge", "Children"}, {"Father", "Age", "Mother", "MAge", "Children"})
in
    #"Expanded Column1"

 

Please see attached files as well

Jayendran's avatar
Jayendran
Icon for Solution Sage rankSolution Sage
7 years ago

Thanks for the solution, Actually I'm missing the ExpandRecordColumn Function