Forum Discussion
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...
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
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.