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.
Hi,
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
You can use PowerBI's built-in connector for free here - https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/
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 - https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/
Link to the Server API - https://docs.atlassian.com/software/jira/docs/api/REST/latest/
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!
Brad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recommended Learning For You
Level up your skills with Atlassian learning
Jira Align Program Essentials
Learn how to use Jira Align at the program level and how to plan for and manage your Program Increment (PI).
Managing Agile Boards and Reports
Learn how to pick the right board type for your team and customize it to fit your specific requirements.
Atlassian Certified Associate
Jira Software Board Configuration
Earn an associate-level credential from Atlassian that shows you can effectively configure Jira Software boards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.