Forum Discussion
API iteration and scheduled refresh
Hi, I have very basic understanding of M and I use data from an API for my report and this requires Iteration. The report refreshes on desktop but I see an error " Some data sources may not be l...
Hi abhigna -
First - I think you can improve your code by understand how to include Relative Path to capture "?limit=XX" part of the URL. Could you please read the following post by Chris Webb to understand this concept?
Chris Webb's BI Blog: Handling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query/Power BI Chris Webb's BI Blog (crossjoin.co.uk)
Second - Your List Generate does not appear to reference Row Start. You have included RowLimit number. I think you might be missing RowStart? i.e. the limit always equals 100, but the row start counts up 1, 101, 201.
Please look at the following from Gorllia BI -How to use List.Generate to make API Calls in Power Query M - BI Gorilla