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.