I was able to connect it similar to @Sean Wood suggestion, but the performance wasn't that good.
If you need further assistance with M (Power BI programming language), here is a step by step documentation on how to do it:
https://community.fabric.microsoft.com/t5/Desktop/JIRA-amp-PowerBI/m-p/329154/highlight/true#M147021
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Become an effective Jira admin
Manage global settings and shared configurations called schemes to achieve goals more quickly.
Streamline Jira administration with effective governance
Improve how you administer and maintain Jira and minimize clutter for users and administrators.
Learning Path
Become an effective Jira software project admin
Set up software projects and configure tools and agile boards to meet your team's needs.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.