cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BobN Frequent Visitor
Frequent Visitor

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 that there are 25 rows.

It is JSON data

I clikc on the List in the first row

The next screen resolves to 10 rows of record with a header that says list. 

Is it only showing 10 rows because this is a preview of the data? Or is this where I have an issue?

I right click on the top row and convert to table. 

Again, 10 rows with a header that says Column1 and a split icon

I expand the Column 1 and get my nice table....but it is only 10 rows.

I select Close and Apply and my report now has the data loaded but only 10 rows.

 

Note: I can send different parameters to the API and get different data but I am always only getting back a max of 10 rows. When I use Postman my GET returns 25 rows just as reported by the query in Power BI....

 

Any ideas are appreeciated.

 

4 REPLIES 4
Super User
Super User

Re: 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?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

BobN Frequent Visitor
Frequent Visitor

Re: GetData from Web API limiting to 10 rows

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 Frequent Visitor
Frequent Visitor

Re: 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?

 

BobN Frequent Visitor
Frequent Visitor

Re: GetData from Web API limiting to 10 rows

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.pngSource

Navigation.png

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 51 members 1,059 guests
Please welcome our newest community members: