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.