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...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I too am getting this very issue. Using Postman I see all my records, but in PowerBI I am only showing 10 records.

 

Look forward to seeing a solution.  Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I found a solution that solved my issue.  The cause is not with PowerBI but rather with the RESTapi I was dealing with.  The RestAPI had a limitation of 10 rows unless I added the following to the end of the REST URL call.

     

    https://*****.com/wp-json/gf/v2/entries?form-12&paging[page_size]=1000

     

    &paging[page_size]=1000

     

    This satisfied the issue I was having.  It is now pulling all the records in the system now.  Note:  I only at this current time have 77 and they are all coming.

     

    I hope this helps out!