Connect On-prim Jira to PowerBI

[Loay Maher Haggag]

Hi, 

I am trying to connect On-prim Jira to PowerBI and I have some questions:

1. Since it is not Cloud Jira, then the only way to connect is through REST API, right?
2. When I get new DataSource I should be using Web not OData feed in PowerBI, right?
3. The REST API that I am using is https://jira.###.com/rest/api/2/search?jql=project=A1EQ&maxResults=100 (I have removed my client's name and added ###) and I had to mention the maxresult & the project name, so how can I make it pull all results & all projects?
4. Then I added the Header as Authorization + Bearer + Token
5. Finally, is there any way easier than my approach?

I am now to Jira and I appreciate ur details answer! thanks!

[Nikola Perisic]

1.Alternatively, depending on the database you are using on server you can connect it with the PowerBI. You can also export Jira stuff (issues, work logs, etc.) in CSV then import it in PowerBI.

2.Web should be used, yes.

[Loay Maher Haggag]

but i guess the export to csv option is not the best practice!

[Nikola Perisic]

Hey @Loay Maher Haggag ,

Have you tried with the PowerBI Connector app? There are two in there, and I would go with Appfire's app.

[Anna Odrynska - Alpha Serve]

Hi @Nikola Perisic 

Server apps are no longer available on the marketplace for the new sales. 

Anna

[Loay Maher Haggag]

Hi @Nikola Perisic & @Anna Odrynska - Alpha Serve 

Dose the Appfire connector work with On-prim Jira server or it requires the Cloud Service?

[Anna Odrynska - Alpha Serve]

Hi @Loay Maher Haggag 

Both Alpha Serve and Appfire connector apps have server versions, but they are no longer available for new sales according the Atlassian End-of-Server policy.

Anna