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 have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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