When uploading data to Power BI, it only allows for a max of 100 rows. How do I get past that?

[Aidan McDowell]

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?

[Mirek]

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.. 

[Ajay _view26_]

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!