This question already has an answer here:

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.

marked as duplicate by Mark Silverberg, Jeanne Holm May 2 '15 at 16:44

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 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.