If developing your own solution doesn't quite fit in with your schedule, or you're looking for a way to quickly link up Jira with Power BI desktop, using a connector add-on will probably suit you much better.Power BI Connector for Jira
from Alpha Serve is the best solution here.
It's a ready-made solution that works right out of the box. All you really need to do to use it is to grab it off the Atlassian Marketplace. It costs $10 for 10 users per year, but there is also a free trial that's available to you in case you wish to try it out before purchasing.
The best thing about using connectors such as this one is that they require no additional skills and knowledge to install and use. You don't need to have any kind of technical background to create an export link. You need administrative privileges to install it though, but even if you don't, you can share the application with your admin and install it that way.
It makes exporting extremely simple. It also supports all fields of data, including tables, custom fields, history, Jira Service Desk, Tempo Timesheets, Tempo Planner, Portfolio for Jira, Agile, Insight, and others.
By default, only the Jira admin is allowed to work with the connector since not all users should have access to it. But you can adjust permission settings if you go to the Manage Apps - Plugin settings in the left navigation menu of the Power BI Connector for Jira.
Let's take a look at how you export your data using this simple but effective tool.