how can i extract data from JIRA like projects ,issues and dump in to another local mysql database where can i build reports by using powerbi. Which is best option to get export data .
Sorry, I didn't link to the document you need - https://confluence.atlassian.com/adminjiracloud/exporting-issues-776636787.html
Use that to get the data, then recreate a JIRA system from it, and use the database it creates.
You do have another option - pull the data you want to report on over REST, but that is not going to "dump data in mysql" - the only simple way to do that is with the export.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot