Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you might find the site temporarily inaccessible. Thanks for your patience. Read more.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Help with getting Jira data into PowerBI

Inna S
Contributor
January 20, 2025

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.

 

3 answers

0 votes
Alexey Pavlenko _App Developer_
Atlassian Partner
January 21, 2025

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.

1.png2.png

Best regards,
Alexey

Inna S
Contributor
January 22, 2025

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.

0 votes
Inna S
Contributor
January 20, 2025

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-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 21, 2025

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

Like Inna S likes this
0 votes
Dan -minware-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2025

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:

atlassian-dev-days.png

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events