how to use Microsoft power bi with jira

[Anton Storozhuk]

Hey @Jen-Qology 

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

[SURESH CHINNATHAMBI]

Hi Anton,

One particular user can't view datasources in Power BI plugin for jira if he is part of powerbi groups and rest of power BI group members can see datasources. Could you please help us on this why it is not working for one user?

Regards

Suresh

[Liubov Topchyi]

Hello @SURESH CHINNATHAMBI ,

Thanks for your question. We started to investigate this case and come back to you soon.

Regards,

Liubov

[Anton Storozhuk]

Hi @SURESH CHINNATHAMBI 

Thanks for contacting us via Support channel. I'll make sure your setup is running smoothly.

Regards

Anton

[Liubov Topchyi]

Hello @SURESH CHINNATHAMBI , 

We've just released the new version of Power BI Connector for Jira - v2.3.6 where compatibility with Internet Explorer was added. 

Please update your instance and let us know if your user is able to see connectors in IE now?

Thank you!

Regards,

Liubov

[Navarambh Software - Gmail]

Hi,

AIO Power BI Connector for Jira app can be used to easily export Jira data into PowerBI and create the dashboards.

It is the #1 selling Power BI connector for Jira on the marketplace and is used by thousands of organizations world wide, including several fortune 500 companies.

It is available for all the three platforms Cloud/Server/Data Center.

If you would like us to provide some samples or have any questions, please feel free to email us at support@aioreports.com or submit a ticket at https://support.aioreports.com

Link to marketplace app page: https://marketplace.atlassian.com/apps/1219072/aio-power-bi-connector-for-jira

Documentation link: https://aioreports.atlassian.net/wiki/spaces/APBCFJ/overview

Support: https://support.aioreports.com

Regards

AIO Support

[Asif Mahmud]

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

[Navarambh Software - Gmail]

Hi,

The problem that you have reported seems to be originating from Power BI Jira Content Pack. 

Please try AIO Power BI Connector for Jira App available on the marketplace here:

https://marketplace.atlassian.com/apps/1219072/aio-power-bi-connector-for-jira

It is available for Jira cloud, server and data center versions. In case of any issues please feel free to reach out at support@aioreports.com

[Anton Storozhuk]

Hi @Asif Mahmud 

We're specializing in creating apps for exporting Jira data to business intelligence platforms like:

• Microsoft Power BI: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=server&tab=overview
• Tableau: https://marketplace.atlassian.com/apps/1221376/tableau-connector-for-jira?hosting=datacenter&tab=overview
• Google BigQuery: https://marketplace.atlassian.com/apps/1221749/bigquery-connector-for-jira?hosting=datacenter&tab=overview
• Looker, Klipfolio, and others are coming soon

Fast & responsive support is here to help you to install and configure the app.

Also please feel free to apply for a discount https://www.alphaservesp.com/blog/up-to-50-off-all-of-our-add-ons-at-the-atlassian-marketplace/

Best regards,
Anton.

[Stuart Terrell]

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?

Thanks 

[Matthew Murphy]

Stuart, was this issue ever resolved? wondering what solutions you found if so? Thanks

[Scott Boisvert]

Any thoughts on connecting Jira Server with Power BI, this blog indicates its only available for cloud.

[Navarambh Software - Gmail]

Hi,

You can try our add-on:

https://marketplace.atlassian.com/apps/1219072/aio-power-bi-connector-for-jira?hosting=cloud&tab=overview

In case of any issues please feel free to email us at support@aioreports.com

Regards

AIO Support

[Anton Storozhuk]

Hi @Scott Boisvert 

We're specializing in creating apps for exporting Jira data to business intelligence platforms like:

• Microsoft Power BI: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=server&tab=overview
• Tableau: https://marketplace.atlassian.com/apps/1221376/tableau-connector-for-jira?hosting=datacenter&tab=overview
• Google BigQuery: https://marketplace.atlassian.com/apps/1221749/bigquery-connector-for-jira?hosting=datacenter&tab=overview
• Looker, Klipfolio, and others are coming soon

Fast & responsive support is here to help you to install and configure the app.

Also please feel free to apply for a discount https://www.alphaservesp.com/blog/up-to-50-off-all-of-our-add-ons-at-the-atlassian-marketplace/

Best regards,
Anton.

[Cyrille Arnold]

Hello, I try to find out how to connect Jira cloud within Power BI desktop. So far, i didn't find any .pbix templates. Any ideas?

[Tiago Machado]

Hi @Cyrille Arnold

Try checking this thread

Regards

[Brendan Walker]

Did you end up getting this to work? I have API connectivity to Excel if that helps. See my comment at https://community.atlassian.com/t5/Jira-questions/Fetch-data-from-JIRA-to-excel/qaq-p/198786

[Monica Labrador]

Has anyone had success with getting data related to a specific project in Jira?

[Tiago Machado]

Hi Monica,

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) ?

Regards,

Tiago.

[Monica Labrador]

Hi Tiago, 

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?

Thank you!

[Tiago Machado]

Hi @Monica Labrador,

On this post I showed how to make Power BI query JIRA using a JQL search.

What you could do is to change the JQL from "assignee = currentUser()" to something like "projects in (projectA, projectB, ...)"

Hope it helps

[Monica Labrador]

Hi @Tiago Machado, 

Your post is helpful.

I was able to use the code provided and modify it to bring in only my project's data. However, the data is aggregated. How would I build a table with the issues and necessary fields I am interested in?

Thank you for your help.

[Tiago Machado]

Hi,

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.

Regards

[Deleted user]

I also cannot get the template to work. I am getting the following message.

GetIssues
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?

[Maitrey Patel]

It is working for On premises installations as well. Can you check that REST is enabled for your JIRA?

[Tiago Machado]

Hi Tjitse,

I think the JQL parameter is missing...

The REST API will return status 400 when there is a problem with the JQL query and 403 when the user doesn't have permission to search.

It wouldn't surprise me if Power BI/ODBC/OLE would say that any 4xx status is 404.

[Nic Brough -Adaptavist-]

Depends - can it talk to JIRA over REST?  What does it do, and what do you want from it?

[Jen-Qology]

Its a data analytics software similar to tableau.

[Nic Brough -Adaptavist-]

Well, I knew that really, but my point is more about what you want from it, and how you propose to connect it to JIRA.

[Jen-Qology]

I wan to be able to pull the data from jira into building more robust dashboard with Jira and also to create reports through Power Bi

[Nic Brough -Adaptavist-]

How do you plan to connect it it? What's the method for "pull"?

[Jen-Qology]

Thats where I'm stuck, the goal is to pull, but now sure how I can accomplish that

[Jen-Qology]

Or even if it its possible

[Nic Brough -Adaptavist-]

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.

[Jen-Qology]

ugh

[Nic Brough -Adaptavist-]

Yes, that's pretty much what I say about a lot of Microsoft Software.

[Jen-Qology]

ditto

[Jen-Qology]

Can I grab the raw data?

[Nic Brough -Adaptavist-]

What do you mean by "raw"? The data in the database?

[Jen-Qology]

Can I export the data in other words

[Jen-Qology]

I just found out I can export from Jira to Excel which is compatible with Power BI such a process! Thanks as always for your help Nic

[David LEPICIER]

In the following link, altassian describe how to create SQL database that you can use with PowerBI or JSON link.

https://tech-connect.atlassian.net/wiki/display/UPH/Microsoft+Power+BI+Connector

[NavinV]

Early this month, a JIRA content pack for PowerBI was released:

https://blogs.atlassian.com/2016/10/jira-content-pack-for-microsoft-power-bi/

[Scott Brier]

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. 

[Jonathan Chatwin]

Scott,

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]

Nevermind - was able to figure it out! 

[Kevin Hess]

Jonathan Chatwin - how did you modify to only get issues for certain projects?

[Dominic Snell]

Hi

Scott/ Jonathan - did you manage to edit the query to pull back any other fields other than the ones in the content pack? If so, could you share please, I'm stuck and need some other custom fields that are not showing in the list.

Thanks - 

Dom 

[Gareth Veitch]

@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:

```Refresh

GetIssues

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):.```