Querying Jira from Excel: error "Access to the resource is forbidden"

[John Prouty]

My query was working fine in Excel and Power BI, until I was forced to change my password. Now, I receive the error "Access to the resource is forbidden". In Excel (and Power BI), I have gone into Data Source settings, cleared all permissions, then re-entered my user ID and new password, but still receive the "Access to the resource is forbidden" error. Even tried entering my old password, but had the same results. Any help is greatly appreciated.

[Mohanraj Thangamuthu]

Hello, Good day. Have you tried the API token instead of password ?. Please refer this link to generate passcode. https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/

Try user name and API token. Thanks