Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira to Power BI

How to get the JIRA data to Power BI? i mean without using the AIO Connector?

I am the only developer uses AOI connector so it doesn't make sense to but license for all JIRA users with this connector license.


So, need help to get data from JIRA to power BI.

1 answer

0 votes
Danyal Iqbal Community Leader Jun 23, 2020


you can connect to the jira database directly if you have jira server and use SQL to get your data or you could get the data from the rest API and save it in a separate database/csv and connect it to PowerBI.

Can you explain me how to get the data using REST API? is it free?

can you provide me the link of REST API?

Hi John,


You can use PowerBI's built-in connector for free here -

This is largely a config activity, similar to the AIO connector, to ensure the connector integrates with your instance properly, and may require some data manipulation in the PowerBI program to create a truly 'clean' data source.


Utilising the JIRA API, whilst more powerful than an out-of-the-box solution, can be much more difficult to get of the ground as you're essentially building a script that can authenticate with your Jira instance, collect & prepare the data, store it in an accessible location (usually as a .json, .xml or .csv file), and have that script run on a batch job to update at a suitable frequency (daily, weekly, monthly etc.).

Link to the Cloud API -

Link to the Server API -

These two APIs are largely similar with regards to their end points, the only key difference being authentication methods can vary between the two.


Hope that helps!


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Agile

Join us LIVE: Atlassian & Experts Talk Research & Insights @ Scale

Hello all! What have you learned from your customers lately? Our live-streamed series continues by exploring CX, UX, and the power of research & insights at scale with Leisa Reichelt, Head of R...

236 views 3 6
Read article

Community Events

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

Events near you