I have a query that appears to identify 975 items per the meta information. I used the limit (100) & skip (25) parameters to get the result. However, if I try to use that same query in Excel (see below) to pull the results it appears to ignore the limit & skip parameters and therefore only returns the 100 based on the limit or 1 if no limit is specified. Is there a way to get ALL 975 items? The URL I am using is:


I am following some of the steps in this video to use powerquery to create a worksheet in Excel.

  • 2
    This has been answered in opendata.stackexchange.com/questions/3259/… (see the first answer). – RCA Jan 12 '15 at 17:34
  • thank you. i understand that there is a limit as well as skip. however unless i am mistaken the limit has a maximum of 100 and skip does not appear to have any impact if pulling the result via ms/excel. – primetime Jan 13 '15 at 19:10
  • I edited your title to make it clear that your problem is related to MS Excel. – Patrick Hoefler Jan 21 '15 at 22:20

I believe the limit is now 1000 with an API key. Try getting and adding an API key and changing the limit to 1000

Not the answer you're looking for? Browse other questions tagged or ask your own question.