Forum Discussion
Multiple calls to the same dataflow
Hi, I have multiple datasets in a dataflow calling the same web API: e.g. https://www.abc.com/page=1, from page 1 to page 19 (and growing). Each page consists of about 100k rows of data. Eac...
You can do this in Power Query, there's lots of information out there on exactly this issue.
some page to look at are:
Loop through Multiple Web Pages using Power Query
Iterating over multiple pages of web data using Power Query
Once you have this working thtough Power Query into a Dataset in Power BI, you can simply copy and paste the "M" code into the Dataflow.
hope this helps
Stuart