Get API data with multiples queries without pagination. Is it possible?

[Anonymous]

Hello,

Currently i can get only 1000 rows with the api call but, i have to get 2000+

I found some information about how to do pagination and differents examples for power query, but i would like to know if it's possible to do this only with PBI configuration, without code and parametres (I would like to be able to work with power bi service and he doesn't like queries with parameters ☹️)

Is it possible?

Thanks in advance for any help

[dax · Accepted solution]

Hi @Anonymous , 

It seems that some API limit the rows to 1000, this is related to API part instead of powerbi(PowerBI limit 10000 max rows per single POST rows request). You could try to set '$limit=' more than 1000 to see whether it work or not. And you also could  use pagination or use paramter to achieve this goal. You could refer to How-to-query-more-than-1000-rows-of-a-dataset  and this post  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @dax 

I'll try it. 😁

Right now i have done multiples gets with different starAt and then i join them in one table (and this is my main table). This way allow me to work with power bi service and scheduled refresh.

Best regards,

Nico