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...
mtlforlife's avatar
mtlforlife
New Member
3 years ago

Echo this same issue. I'm using the Web connector against a web page that includes 2 HTML tables with more than 10 records each, but Power Query trims the dataset to 10 records. I can read the source code and see the HTML code. I tried modifying the Power Query M Web.Contents() and/or Web.BrowserContents() before being passed to Web.Page(), verifying the same code, reducing the code to just the </table> tags thinking client side script may have been trimming the records, but to no avail.

 

Any help/insight would be appreciated, please let me know if you need more details. My source is an intranet page, so I can't directly offer it for trouble shooting.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Did you try passing the paging variable over?  That was the issue I encounted.  My API had a default of 10 records until I added this.  Please see my resposne below.

 

Rick

  • mtlforlife's avatar
    mtlforlife
    New Member
    3 years ago

    Thank you, I tried this suggestion from prior review of the post. It does not change the dataset return limited to 10 records. The HTML return in a browser, Postman and Power Query has the compliment of all records exceeding 10, but the trim seems to be occurring in the Html.Table() call or somewhere else in Power Query.