Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

how to fully load data from limited HTTP API?

I need to load all data from the API, but the server returns a maximum of 100 rows. at the link below, if I change the limit=100 to a bigger number, it returns with 100. to get more data, I need to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I can work with this script for a short period of time, as it is not future proof.

But now I found another problem and I need a workaround:

I cannot refresh data online (also scheduled refresh) because of the limitation of the PBI Service.
I am using a function inside the URL and this is not allow for PBI Service.

In bold, the forbidden function inside URL:

each Json.Document(Web.Contents("https://url.com/token?limit=100&offset=" & Text.From([Column2]) & "&date_range=201001010000:201912310000")))

Can anyone please help me with another way to load all pages from API and solve this issue?

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

Unfortunately this is a current limitation of the service.  I believe the PG is actively working on or discussing enabling this type of query to be refreshable but AFAIK there is no workaround.