Forum Discussion

BobN's avatar
BobN
Frequent Visitor
7 years ago

GetData from Web API limiting to 10 rows

I am relatively new to Power BI and am certain that this is just a beginner issue but I cannot solve this.   I connected to the Rest API by using WEB connector. The data pulls down and reports tha...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

I don't suppose that you could post the URL to the API or the raw JSON that you are getting back?

BobN's avatar
BobN
Frequent Visitor
7 years ago

Thanks for your response.

 

It is a MIRAKL API and even though it is a test system I cannot post the full url since it has a key which needs to remain private.

 

But this is a good hint. I should try another API that is public and see if I have the same problem.

 

Follow up Question. I can see the JSON as I work with it in query editor. the first step in query editor has the top level of the JSON displayed as LIST and row count of 29....how would I get the value of LIST? e.g. the raw JSON.  I do see it fine in Postman.  

  • BobN's avatar
    BobN
    Frequent Visitor
    7 years ago

    I added an API for beer recipes https://api.punkapi.com/v2/beers It has a default limit of 25 rows. All of these pulled into power bi. I am sort of stuck. In postman for the mirakl api I am getting 29 rows but in Power bi only 10 display. However the initial view says there are 29 rows.  How would I  view the raw JSON?

     

    • BobN's avatar
      BobN
      Frequent Visitor
      7 years ago

      To help put my dialog in context.

      The 1st step in query editor (Source) shows 29 records and the next step only shows 10 after I click List

      Source

       

      • Jaxem's avatar
        Jaxem
        Regular Visitor
        5 years ago

        Did this ever get figured out? I'm trying to pull data from the MailChimp API and having the same issue. 1500+ members in the list, but only 10 getting pulled down.