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

| improve this answer | |

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