I've created an API token and have uploaded the data through the Web option in Power BI and I get the information I need, but not all of it. It shows me a maximum of 100 rows when I need much more. How do I get by this obstacle?
Hi @Aidan McDowell
Unfortunately on Jira Cloud there are limits how many objects can be used though API..
https://jira.atlassian.com/browse/JRACLOUD-67722
The workaround might be to modify your Web Query and use pagination on the specific request
Set maxResults=100
Increment startAt (0, 100, 200, 300, etc.)
Example:https://your-domain.atlassian.net/rest/api/3/search?jql=project=XYZ&maxResults=100&startAt=0 ... then startAt=100 .. etc. until you get total..
Hi @Aidan McDowell ,
If your dataset is relatively static, you can export issues from Jira using JQL (up to 1,000 at a time via UI export), then import the CSV into Power BI. Less elegant but works immediately.
Hope this helps!
It looks like you're new here. Sign in or register to get started.
