Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,492
Community Members
 
Community Events
165
Community Groups

How to connect power bi with Jira cloud

Good evening community I would like to know if someone could tell me if there is a way to connect Jira Cloud and Power bi without using a connector or application?

5 answers

2 votes

If you don't want a "connector", then you are stuck, you're explicitly ruling out connecting to it.

Broadly, your options (all of which can be described as a "connector") are:

  • Use an app that understands Cloud Jira and Powerbi, enabling them to talk to each other
  • Get Powerbi to use REST calls into Cloud directly to extract what it thinks it needs (painful and re-inventing the wheel, seriously, get a connector app)
  • Extract data manually for upload into Powerbi (of course, that's slow, manual hard work, and your data is obsolete the instant you extract it)
  • I don't know Powerbi that well, but you may find it works well with a direct connection to the upcoming data lake (currently being trialled by a load of people here)

this might be the best, most comprehensive answer I've seen around. There are a lot of folks asking similar things lately and this pretty much summarizes all the options (that I know of)

Like # people like this

If you want to obtain the list of filters use this method then

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-filters/#api-rest-api-3-filter-search-get

It seems you're successfully stablishing a connection, which honestly could be the trickiest part some times. Now you just must browse the API documentation a bit and you'll be able to get anything.

0 votes
Jack Brickey Community Leader Jul 23, 2021

Yes you can connect Jira Cloud with PBI. Here is an old blog that might assist - explore-your-jira-data-with-power-bi 

Hello there, Jack :) 

But he has said he doesn't want to use a connector...

Yes understood however, to be honest, I wasn’t exactly sure what his definition of connector was. For example, “connector” might translate to “paid addon”. Often people ask for a free solution in different ways.

Like Iago Docando likes this

I was unsure too, and tried to define what it sounds like to me before trying to answer!

Hello everyone and thanks for responding, @Iago Docando  @Nic Brough _Adaptavist_  @Jack Brickey  maybe I did not explain and specify how to connect by saying that without using a connector I am referring to a payment tool or an application from the Jira store, I tried to connect through an API, it was this: https : //edenredmx.atlassian.net/rest/api/2/search? maxResults = 100 & jql and it sends me the following results, but I would like to obtain the filters that I have saved in my state.

attached images.

Power bi 1.jpgPower bi 2.jpgPower bi 3.jpg

>by saying that without using a connector I am referring to a payment tool or an application from the Jira store

I think we kind of guessed that, which is why we focussed on the direct REST API connection when we were talking about it!

Anyway, you can get to your saved filters with the REST API at https://docs.atlassian.com/software/jira/docs/api/REST/1000.824.0/#api/2/filter

Jack Brickey Community Leader Jul 27, 2021

To be clear the link I provided does not require any addon from Atlassian Marketplace. If you have an O365 account the you can use it to connect PBI  with your Atlassian Cloud instance. In rhythm link you will see a “Try Jira with Power BI” button that will redirect you to a O365 login. Granted, depending on your O365 account level (E3, E5…) there is a PBI cost but that is the case regardless of any connection method.

Jack Brickey Community Leader Jul 27, 2021

For grins, I logged into my PBI workspace and found an old space I created back in 2017 and it is still active …

EFE7F322-1451-4839-9565-02F9D716C4BE.jpeg

Like iagodb likes this

2017. Not from the original batch but definetely an early bird :) I didn't got to power BI until 2019 myself and I can't praise it enough. It has it made my life easier when it comes to reports. 

[edit] ups... wrong account :P

I followed the link from Jack, but how do I even get to see a list of available content packs in PowerBI? I'm using Jira cloud, too. Thanks!

I don't think you can. I've connected Power BI to several jira SERVER's API no problem but when I've tried to do the same with a cloud instance I couldn't so I guess it might be capped on purpose.

Take this at face value only. I'm not sure by any means. I just tried to do that once, like a year ago... 

@Victor Tobon  I think if you don't want to use a connector or plugin then only way to do it would be you taking a dump of your tickets from Jira in an Excel and then uploading then to PowerBI

I would also be curious to see if anyone else has achieved it without using any connector

@ASHU TYAGI  

to what and investigated can be done through an api and the token from pober bi I have the api and the token however I do not know how they should be placed

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

287 views 2 9
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