Pulling in Data from Jira (company web link) and only shows 50 rows

[Anonymous]

Hello everyone,

I am attempting to use a FILTER I created in Jira to link to Power BI.  I read many articles about how you can pay to build filters that Jira offers and basically does all this for you.  I also know you can simply build a filter in Jira, export it to excel and then utilize Power BI with the excel document.

What I am looking to do is create a direct connection from my company Jira to Power BI.  I was able to downlaod a content pack and establish a connection using that.  But, this did not have all the fields I needed.

My next step was to create a filter in Jira, then use the URL and use the WEB function in Get Data.  I was able to use that sucessfully but now this data only shows 50 rows in power query and also when I use data visualizations.

I am confused because the content pack I used pulled over 500,000 rows of data.  The query that I built in Jira should list over 86,000 tickets/rows.  I only get 50 rows?  How is this possible.  I dont see any limit settings in options in power bi.  

Can someone help with what I am doing?  Do I need to go into the advanced editor and change something?  I dont understand why a content pack can utilize over 500,000 rows but when I pull a filter directly from Jira using WEB in power BI, I only get 50 rows. 

[Anonymous]

I tried this suggestion but I noticed that if I increase the maxResults past a certain number the connection will timeout.  I am not sure how to get past this point because I need to puy thousdands of rows.  

Here is what I am seeing right now:

What your saying is, I need to create a query off this API I created?  But, the API only picks up 100 rows?  I dont think I follow how this is going to retrieve data that does not exist in this API?

[jaweher899]

It's possible that the Jira API endpoint that you are using has a limitation of returning only 50 rows at a time, and Power BI is only able to retrieve this limited data. To retrieve more data, you can try paginating the API endpoint to get more rows of data.

Here are the steps to paginate the API endpoint:

1. Modify the API endpoint URL to include the startAt and maxResults parameters. For example: https://yourjirainstance.com/rest/api/2/search?jql=yourjql&startAt=0&maxResults=100

2. Replace the startAt value with the starting record number and the maxResults value with the number of rows you want to retrieve per API call.

3. In Power BI Desktop, use the Get Data > Web function to retrieve the API data.

4. Load the data into Power BI and create a custom query to extract the data from the API.

5. Modify the custom query to add a loop that will iterate over the API calls to retrieve all the data.

6. Load the data into Power BI and create your visualizations.

By following these steps, you should be able to retrieve more data from the Jira API and avoid the limitation of 50 rows.

[Anonymous]

Thank you I will try this suggestion!