Forum Discussion

Jayendran's avatar
Jayendran
Solution 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Jay,

 

Since you have a standard JSON file, I would suggest you use the built-in connector JSON and follow the steps one by one. The underlying code will be generated by the Query Editor automatically.

 

 

Best Regards,