Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
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
I found the solution in this video!
https://www.youtube.com/watch?v=hHkU8tPhVXs&t=492s
!!! Thank you for Hoosier BI !!!
Best Regards!
Zoltan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |