Extracting information from Jira?

[MR2001]

Hello,

I am new to Power BI and I need to extract information from a Jira database and generate charts. If anybody can advise in this matter it will be much appreciated. What I need to know is the query syntax and the method of authentication.

Thank you,

M.R.

[antonstorozhuk]

Hello @MR2001 

I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.

We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.

Cheers!

Anton

===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[skasper]

Power BI recently added a connector to JIRA. We use it with hosted JIRA and it works well.

Just click on 'Get Data', 'Services' and select 'JIRA'.

[jbertozzi]

What kind of authentication are you using? We have here the admins with jira databse user, and we tried without success. Please could you share with us? We have hosted JIRA here. 

[skasper]

It's not clear, whether you use JIRA on premise or hosted. You might find this useful: https://tech-connect.atlassian.net/wiki/display/UPH/Microsoft+Power+BI+Connector

[ankitpatira · Accepted solution]

@MR2001

If you can connect to database, from powerbi desktop you can use SQL server or oracle database connector depending on the database. If you are unsure of db schema, default JIRA connector is not yet available and you can vote for the idea using below link.

https://powerbi.uservoice.com/forums/265200-power-bi-ideas/suggestions/7031232-jira

[MR2001]

Thank you for the information, I submitted my vote.