Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
18 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
15 | |
9 | |
3 | |
3 | |
2 |