Power BI and Jira CLOUD direct integration. (Novice here)

[mari_guernsey]

Hello

I am a Scrum Master for multiple teams and helping a larger group of teams in my division in getting data exported from Jira (cloud) to Power Bi.

No one at our company had implemented a direct integration. (Azure Dev ops has this functionality)

Is this possible (direct integration), or do we always have to use a third party app?

Is there any documentation showing step by step instructions on how to install, configure, do this connection, upload of data.

- direct integration

- Using an app

I did do a search FIRST in the community for this topic, but I got a bit confused as Jira Server was mentioned all the time, and I wasn't sure if this instance is different from Jira Cloud? (maybe it should be obvious, but it isn't)

Thank you everyone for your time. 

[Sayed Bares _ServiceRocket_ · Accepted solution]

@mari_guernsey

 Jira Cloud and Jira Server/DC (on-prem) are different products with different functionality, pricing, and architecture. Jira Server/DC is hosted and maintained by the customer while Jira Cloud is hosted and maintained by Atlassian (the easiest way to confirm is looking at your URL if it is <site-name>.atlassian.com then it is cloud).

As for the integration between Jira and Power BI you have two options:

1. Use a third-party app (https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=power%20bi)
2. Export your Jira data .csv format manually and then import it in Power BI

[mari_guernsey]

@Sayed Bares _ServiceRocket_ wow you are really amazing and SO very helpful. Yes I confirmed we are on Jira Cloud. I will check into the options you mentioned. 

Appreciate your input!

Mg

[Maksym Kaprarenko _DOIT-BI_ · Accepted solution]

Hi @mari_guernsey 

If you are searching for a free option for direct integration you can try to find a solution in this topic:
https://community.atlassian.com/t5/Jira-Service-Management/How-to-connect-power-bi-with-Jira-cloud/qaq-p/1757343

But if you are also considering using a third-party app you are welcome to try our Microsoft Power Bi Connector for Jira. You will have a 30-day free trial to decide whether it's the best solution for your needs or not. 

Best regards,
Max

[mari_guernsey]

Thank you @Maksym Kaprarenko _DOIT-BI_ 

[Anna Odrynska - Alpha Serve]

Dear @mari_guernsey 

I can comment on the "using the app" part of your question :)

Here is a detailed steb-by-step guide how to do this using Power BI Connector for Jira app:

- install the app

- configure the application

- export data to Power BI

In case you get interested in this option, feel free to schedule a live demo session with our team to explore more features and functionality.

Cheers,

Anna from Alpha Serve