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?
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:
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you want to obtain the list of filters use this method then
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes you can connect Jira Cloud with PBI. Here is an old blog that might assist - explore-your-jira-data-with-power-bi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello there, Jack :)
But he has said he doesn't want to use a connector...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I was unsure too, and tried to define what it sounds like to me before trying to answer!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For grins, I logged into my PBI workspace and found an old space I created back in 2017 and it is still active …
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.