Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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...
Need Help
Tips and Tricks
  • dax's avatar
    dax
    6 years ago

    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.

     

dax's avatar
dax
Community Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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