Atera API import limitation

[JudgElf]

Hello,

when I import the data from Atera API to PowerBI there is a 50 items limitation on Atera side.

The imported table is contains the next/previous page link fields, like: https://app.atera.com/api/v3/tickets?page=2&itemsInPage=50

Do you have any idea how can I import all pages in to one table? 

Many thanks!

Zoltan

[v-rzhou-msft]

Hi @JudgElf ,

As far as I know, this limitation should be set by Atera API. I think in your API URL there should be some code to link to the determind page and the data limitation in each page should be 50.

You can try to change this in data source.

Best Regards,
Rico Zhou

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

[JudgElf]

Hello @v-rzhou-msft ,

thanks for your ansver!

It wasn't a question, as you can see the original post link I clear about the 50 limitation and how to get pages.

The question is:  how can I import this 50 row/pages to one table if I have 33 pages? ( without add the sources one by one)

Thank you!

Zoltan

[JudgElf · Accepted solution]

I found the solution in this video!

https://www.youtube.com/watch?v=hHkU8tPhVXs&t=492s

!!! Thank you for Hoosier BI !!!

Best Regards!

Zoltan