...
Create a local Jira user account, grant this user permission to work with the connector. Afterwards SSO users can create connectors from their usual Jira accounts and share them with that local users accounts and use the local user's credentials for exporting Jira data into Power BI Desktop. Please note that all data can be exported according to Jira permission schemes.
Install “API Tokens for Jira” or "API Token Authentication Jira" app https://marketplace.atlassian.com/ apps/1221586/api-token-authentication-jira?hosting=server&tab=overview. Creating and using an Authentication Tokens resolves the issue with “Access to the resource is forbidden” error.
...