Forum Discussion
snowrider1799
6 years agoHelper I
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...
lbendlin
6 years agoSuper User
Does it have to be Power BI? Could you pull that web contents with curl or Powershell , place it into a single CSV file ( I can show you a simple Powershell script for that) and then feed that one file to your dataflow?
snowrider1799
6 years agoHelper I
Hi lbendlin ,
I have 19 pages, and total about 2mil data, it will continue to grow in times.
For dataflow #1, i am supposed to combine 19 pages with 5 columns (for example).
Can this be done via the powershell? If yes, i will be interested to know.