Forum Discussion
Connecting API in powerBI
Hi All,
I Have an API with SCROLLID.
when the API Runs for the first time, there is no ScrollID.
The First Call returns a ScrollID for 2nd , 2nd Call will return ScrollID for 3rd & So on...
The Last time when all the rows are Exhausted, the SCROLLID will be NULL
there are aboiu 2,00,000+ rows of Data
From Each Call, we will be getting 5000 records.
Please help with the code for the same
1 Reply
when the API Runs for the first time, there is no ScrollID.Either handle the first call separately (as you can do in List.Accumulate) or specify a fake SCROLLID of 0 when doing the first call.
