Forum Discussion
GetData from Web API limiting to 10 rows
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
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.
Did you ever have any luck? I'm also trying to pull data from MailChimp API and only getting 10 rows...
Hi jakec As a workaround, maybe you can use a 3rd party connector. It will pull the data from the API too but you won't have the issue of only getting 10 rows or a limited amount of rows. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Mailchimp connector in the data sources list:
After that, you will have to first create a secret API key in your Mailchimp account and then using your credentials add your account to the platform.
Once you’ve done this, you can proceed and go to the “Preview and destination” step
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
