Forum Discussion
GetData from Web API limiting to 10 rows
I don't suppose that you could post the URL to the API or the raw JSON that you are getting back?
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.
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?
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
Hi Greg. I'm having the same issue - trying to pull down a long list of orthopaedic surgeon data from an API source (national provider identifier database), but only getting 10 back. Here is the API: https://npiregistry.cms.hhs.gov/api/?version=2.1&taxonomy_description=orthopaedic+surgery
