I'm using Jira Search API to get all issues for my project in Power BI.
Below is the API URL used:
Total records are around 9000, however, only 4000 are pulled.
How can I fetch all the 9000 records in Power BI using this API?
In this case, you can try our Power BI Connector for Jira app.
It makes exporting extremely simple without the limitations you face when using the API. It supports all fields of data, including tables, custom fields, history, Jira Service Desk, Tempo Timesheets, Tempo Planner, Portfolio for Jira, Agile, Insight, and others.
I hope this will be helpful
Marketing Manager at Alpha Serve
Directly from the mouth of the beast:
The maximum number of items to return per page. To manage page size, Jira may return fewer items per page where a large number of fields are requested. The greatest number of items returned per page is achieved when requesting
I'm surprised you can pull 4000 issues at once. Normally you're only able to pull 100 at a time or 1000 if you limit your fields to id or keys only.
The solution is to perform multiple requests using the startAt parameter.
Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events