Our team released Jira plugin, which allows to create Data Sources for Power BI (with a feature to filter projects and/or fields). Makes life easier for a non-techie https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=server&tab=overview
Not sure if I can jump on this thread or not (but will try anyway) I can't get the template to work, I'm at the Connect to JIRA step.
I've entered the URL and used Authentication method Windows but get the following error: Failed to update data source credentials
Any ideas what I need to do/check?
Hi Support team,
I tried but this is not working. Is there other ways to pull the DATA from JIRA to Power BI? I tried to get JIRA content pack in Power BI but the screen freezing after i enter the JIRA link and Basic Credential. I have attached a screenshot below...not sure what I am doing wrong. Appreciate your help.
Thanks in advance
You can use AIO Power BI Connector for Jira App available on the marketplace here:
It is available for Jira cloud, server and data center versions. In case of any issues please feel free to reach out at email@example.com
The best option is to use REST - it doesn't change much, when it does change, the changes are usually "make more stuff available" and it's available off-the-shelf. But does Power BI support that? At a guess, it'll probably demand access to the database, which is a nightmare because you'll need to build and maintain data dictionaries.
Just found this thread - I've been able to crack this using a content pack with some minor tweaks on my end. Happy to share some insights if anyone still has the need.
Here's the content pack link that includes the functions needed: https://onedrive.live.com/?authkey=%21AH4_6OHXy6siE74&cid=E7E2C1CD5556023F&id=E7E2C1CD5556023F%21116639&parId=E7E2C1CD5556023F%21116638&action=locate
Using query functions that produce a REST call using search - then using PBI's query editor to break out the result (json) into table fields. No DB required.
Then you can use DAX to do some pretty neat stuff.
I've loaded up the content pack and it tends to get stuck on 'getissues' after I provide basic authentication. I was only able to get it to load all issues (all 100,000+!!) once yesterday.
Do you have any insight as how to modify to only get issues for certain projects? I'm new to PowerBI:)!
@Jonathan Chatwin how did you figure it out? That's where i'm getting stuck too...
Try to give it ```https://jira.csc.com/rest/api/2/search```
and it spits back:
OLE DB or ODBC error: [DataSource.Error] WebContents failed to get contents from 'https://jirea.csc.com/rest/api/2/search/rest/api/2/search?maxResults=500&startAt=0' (404):.```
I also cannot get the template to work. I am getting the following message.
OLE DB- of ODBC-error: [DataSource.Error] Web.Contents kan de inhoud niet ophalen van 'https://nameprojectof.myorganisation.local/rest/api/2/search?maxResults=500&startAt=0' (404): Not Found.
Is it possible that this template does not work for on-premises instalations?
Yes - I was able to make Power BI to run a custom search/query on JIRA and parse its results. In our case, we were required to create a Power BI page with indicators about worklog data.
Is it similar to your needs ?
How familiar are you with Power Bi (create/edit a query on advanced query editor) ?
Thank you for your reply. I was able to edit the query using advanced editor to increase the number of rows returned. I am looking to query for only our projects data. The organization I work for has many departments that use Jira and they each have their own Project.
Do you know how one would add a project key parameter?
The "data" you retrieve at the end of my script is a list. So, the first thing to do is convert it to a table (List Tools/Transform -> To Table).
Then you will have a "Column1" with some records. Click on the icon with two tiny arrows on the right of the Column1 to expand its values:
You may select all and then delete the columns you don't want later or select just the values you are interested in.
Then you will have something more likely to a useful table. But the important values aren't available yet. Their are still "grouped" under the "issues" column. Repeat the expand process (click on the two arrows icon), expanding the values to new rows.
And you should repeat the expand procedure until all the important data is available in columns for your reports use.
You can try our add-on:
In case of any issues please feel free to email us at firstname.lastname@example.org
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
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