Good afternoon,
I am quite new to Power BI but have connected a few datasources.
I used the Power BI Service, Web API to connect to Dotdigital. I created a flow for the Contacts - we have over 150k records. However I only get 1000 records back, i belive this is due to their API limitation. (I added the dataflow to PBI Desktop to check and confirm there are only 1000 records total). To get around this issue before I used a script to get the 'next page' and the 'next' (and so on) then compile the list. When I tried this script on this API I got the same 1000 records every time. (I added the flow to PBID and had 1000 unique but 200,000 total records.)
I am looking for a way to get collect the first 1000 records, then the next 1000s until I get all of the contacts. Can anyone please assist with some code I can use or base my research on? Thanks in advance
