Forum Discussion

datatbl123's avatar
datatbl123
Helper I
4 years ago
Solved

Format JSON into a table Power BI

Hi,   I have an issue where the first column pulling from the data is displaying as a column header but it should be the first option on line 1. Can anyone help with the current code I am usi...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    let
Source = Json.Document(Web.Contents("https://website.com/customfielditems?customfield_id=72879", [Headers=[Authorization="Key"]])),
customfielditems = Source[results][customfielditems],
    #"Converted to Table" = Record.ToTable(customfielditems),
    #"Removed Other Columns" = Table.SelectColumns(#"Converted to Table",{"Value"}),
    #"Expanded Value" = Table.ExpandRecordColumn(#"Removed Other Columns", "Value", {"id", "name"}, {"id", "name"})
in
    #"Expanded Value"
lbendlin's avatar
lbendlin
Super User
4 years ago

sorry. As Anonymous said you need to lose the "Promote headers"  step.

datatbl123's avatar
datatbl123
Helper I
4 years ago

Ok, I did remove the "Promote headers" and now I am getting this error

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago
    let
Source = Json.Document(Web.Contents("https://website.com/customfielditems?customfield_id=72879", [Headers=[Authorization="Key"]])),
customfielditems = Source[results][customfielditems],
    #"Converted to Table" = Record.ToTable(customfielditems),
    #"Removed Other Columns" = Table.SelectColumns(#"Converted to Table",{"Value"}),
    #"Expanded Value" = Table.ExpandRecordColumn(#"Removed Other Columns", "Value", {"id", "name"}, {"id", "name"})
in
    #"Expanded Value"