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.
I'm John Allspaw, co-founder of Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs