Help with getting Jira data into PowerBI

[Inna S]

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://<my site url>/rest/api/3/search?jql=project=MyProj url results in an error 400 Bad Request.

I do pass the Authorization="Basic <endcoded api key"> 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.

[Alexey Pavlenko _App Developer_]

Hi @Inna S ,

1. 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).
2. Please read https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#pagination 
3. 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

[Inna S]

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.

[Inna S]

Hi @Dan -minware- , 

thank you for suggestion. 

Unfortunately I have a big issue with the Atlassian mode of work with any 3rd-party apps as they provide too much uncontrolled access to them with zero audit to the site admin. So whenever possible we avoid the marketplace apps. 

But it is good to know there is a fallback option.

Thank you and good luck.

Inna

[Dan -minware-]

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

[Dan -minware-]

Hello @Inna S - Sorry I don't have the answer here but it sounds like you are going to be pushing the limits of what's possible natively and wanted to suggest our 3rd party application (minware) - we are are able to work around these limitations and blend data from Jira, Git, Calendars, and CICD sources:

It is a paid 3rd party service but we offer a free trial if you want to check it out!