title: Json to excel using power query
body: <p>I have some <code>json</code> on a website that i want to convert to <code>excel</code> using the <code>power query</code> option <code>from web</code>. But  I ran into a small problem. My <code>json</code> looks like this:</p>
  
  <pre><code>[
      {
          "id" : 1,
          "visitors" : 26,
          "some_number" : 1,
          "value" : 3500
      },
      {
          "id" : 2,
          "visitors" : 21,
          "some_number" : 5,
          "value" : 2000
      }
  ]
  </code></pre>
  
  <p>but when i use <code>from web</code> i get this:</p>
  
  <p><a href="https://i.stack.imgur.com/GoIHb.png" rel="noreferrer"><img src="https://i.stack.imgur.com/GoIHb.png" alt="enter image description here"></a></p>
  
  <p>I can drill down into a record,convert it to a table, transpose and use first row as header but then i get just one row. How can i get all of my data to the table and not just one row?</p>