title: How to get paginated data from API in Power BI
body: <p>Let's say we have this endpoint <code>https://reqres.in/api/users</code>.</p>
  
  <p>The response is </p>
  
  <pre><code>{
      "page": 1,
      "per_page": 3,
      "total": 12,
      "total_pages": 4,
      "data": [
          {
              "id": 1,
              "first_name": "George",
              "last_name": "Bluth",
              "avatar": "https://s3.amazonaws.com/uifaces/faces/twitter/calebogden/128.jpg"
          },
          {
              "id": 2,
              "first_name": "Janet",
              "last_name": "Weaver",
              "avatar": "https://s3.amazonaws.com/uifaces/faces/twitter/josephstein/128.jpg"
          },
          {
              "id": 3,
              "first_name": "Emma",
              "last_name": "Wong",
              "avatar": "https://s3.amazonaws.com/uifaces/faces/twitter/olegpogodaev/128.jpg"
          }
      ]
  }
  </code></pre>
  
  <p>Here is the result in PowerBI</p>
  
  <p><a href="https://i.stack.imgur.com/lX4Ei.png" rel="noreferrer"><img src="https://i.stack.imgur.com/lX4Ei.png" alt="enter image description here"></a></p>
  
  <p>So my questions are :</p>
  
  <ul>
  <li>How can I play with the content of <code>data</code>, instead of showing the string <code>"[List]"</code> only?</li>
  <li>Can PowerBI  handle the pagination? Can it change the <code>page</code> param? <code>?page=X</code></li>
  </ul>