Help with getting Jira data into PowerBI

Question

Hi, I'm trying to pull the basic data from Jira (cloud) into PowerBI and other than using a search endpoint of the API, nothing works. For example, passing https:///rest/api/3/search?jql=project=MyProj url results in an error 400 Bad Request. I do pass the Authorization="Basic and this works when using the basic /search?project=MyProj, but any attempt to use jql fails. Same error is when attempting /search?filter=1111. The same url works fine in the browser. Atlassian support helped me get the basic using the simple /search? endpoint, but jql and filter do not work. The hard limit of the 100 issues returned by the search is another trouble as a single project where I'd need to start already contains 900+ issues, so we really need to bother fine-tune the query and figure out how to paginate it. Any help will be appreciated.

Inna S · Answer

Thank you, Alexey.

The problem is that I've started with the
rest/api/3/search?jql=project=MyProject

and while this works in the browser, it fails inside PowerBI with the (400): Bad Request error.

Replacing the project key with the project id makes no difference.

Your app looks cool, but we are looking for a different type of stats, outside of the scrum metrics world.

Thank you.

Alexey Pavlenko _App Developer_ · Answer

Hi @Inna S ,

* Please try to use JQL explicitly instead of incorporating a saved filter. Your query might not work due to the permissions of the filter or the JIRA REST API policy (which can be checked on the relevant REST API page).
* Please read https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#pagination 
* You can try the application I developed - Multi-team Scrum Metrics & Retrospective.
It's a Forge application which doesn't send data anywhere outside the Atlassian ecosystem. The data preserved within the same boundaries as all your other data. You can double-check it on the app marketplace page I shared above.

The app is highly customizable and solves a wide range of tasks.

Best regards,
Alexey

Dan -minware- · Answer

@Inna S no problem. Please reach out if we can ever help!