nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to connect power bi with Jira cloud

Victor Tobon

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?

Accepted answers

All comments

Ashu Tyagi

@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

Victor Tobon

@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

Iago Docando

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...

Jack Brickey

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

Iago Docando

Hello there, Jack

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

Nic Brough -Adaptavist-

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)

Jack Brickey

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.

Nic Brough -Adaptavist-

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

Iago Docando

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)

Iago Docando

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

atl-gruland

jira-service-management-cloud

jira-service-management