Using get data from web to pull Jira data was working but suddenly getting auth failures on load

[Brian Allen]

Used Get Data from Web and able to preview the Jira data. But when I click on Load, I get an error that I am not authorised which seems odd since the data is showing in the preview.  Any suggestions?

[Joachim Harter]

I managed to fix my particular issue using a Jira API token sent as part of the HTTP Authorization header.

This article helped me in particular: https://developer.atlassian.com/cloud/jira/platform/jira-rest-api-basic-authentication/

[Joachim Harter]

I'd be interested in a solution, too.

I'm having a what looks like a similar problem. For months I've been working with an Excel workbook which uses Power Query to get CSV data from Jira. Just recently the query stopped working. Excel doesn't return the expected CSV data but HTML for the login page.

When I re-enter my credentials in the data source settings, Excel says my username and password are not valid. 

When I enter the same URL in a browser, I get the correct CSV data.