It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Connect Power-BI to Jira Server Edited

Ward Schwillens Aug 24, 2018

I'm getting confused here. Is it possible to connect Power-BI to Jira (on premise) Server or is it not? Basic Authentication and HTTPS are enabled.

3 answers

1 vote
Avinash Singh Jan 10, 2019

You can connect to Jira server on premise using power bi desktop using the Jira_PowerBI_ContentPack.pbit (https://drive.google.com/file/d/1rc7ngRHPH38AWwHEMKJ6mcPjhSVT-rJe/view)

Ran Inbar I'm New Here Jan 20, 2019

Hi , i was able to connect my PowerBI to the Jira server ( reading a project )

 

however when i am trying to get the epic information ( see the below REST ) i am getting 400 error ( the same REST return results using a browser 

https://acjira/rest/api/2/search?jql=issueFunction%20in%20hasLinks(%22Business%20Requirement%20of%20Epic%22)

 

any suggestion ?

0 votes
Tarun Sapra Community Leader Aug 24, 2018 • edited

Hello @Ward Schwillens

If both are reachable via the network, then I don't see any issue in connecting both. Jira is supported out of the box by power BI

https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/

Sean Vana I'm New Here Apr 30, 2019

It's for cloud only and we are talking about on-prem

0 votes

Hello - 

I am attempting to get my Jira data connected to PowerBi. I am confused about the above link because it seems as though it is linking Jira with a browser based version of PowerBi.

I have the PowerBi client installed on my computer and would like to get my Jira data there. Does anyone have any suggestions?

Avinash Singh Feb 14, 2019

You can use the desktop app.

https://powerbi.microsoft.com/en-us/desktop/

Hi Avinash - 

Thanks for the response. Maybe I am missing something, but I do have the PowerBi desktop app. I use it for various things. I am just trying to figure out how to link my Jira data to it.

Any suggestions?

Like David Lopez likes this
Avinash Singh Feb 18, 2019

Once you download the content pack, when you executed you should be able to configure it point to your jira endpoint or even a jql filter through the api.

I do have PowerBi desktop installed on my computer and I use it for other things. As for linking my JIRA data to PowerBi I am confused. The initial link at the beginning of this thread doesn't appear to link JIRA data onto PowerBi desktop.

I must be missing something.

Federico Scheu Apr 26, 2019

Hi Mike,

You have to use the powerbi file in this link:

(https://drive.google.com/file/d/1rc7ngRHPH38AWwHEMKJ6mcPjhSVT-rJe/view)

 

Regards,

Federico.-

Marcel Vlems Jun 07, 2019

Hello Frederico, I opened the template in PowerBI Desktop and I'm able to fill in the credentials, using basic authentication with the same credentials as I normally use. We have Jira Server but it's accessible from the outside. When I have entered all data, PowerBI seems to be making a connection, but eventually I get the error 

GetIssues
OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://myurl:8443/rest/api/2/search?maxResults=500&startAt=0' (500): 

Any idea how I can solve this?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

9,956 views 45 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you