I'm using Power QueryinExcel to obtain issues from Jira viaa web data source. The source and subsequent query have previously worked fine using the same credentials (reinforced by 29 day old cached results) but it will no longer refresh, reporting "We couldn't authenticate with the credentials provided. Please try again."
If I paste the source link into a browser, the .csv file is successfully downloaded.
If I attempt to recreate the query in Excel by adding data from web, specifying the Jira .csv link and configuring "basic" credentials (my Jira login details) in the "Access Web content" dialog, the error persists, indicating "use anonymous access for this web content" (which is counterintuitive given the requirement to login and doesn't help). When I click "Basic" again, all of my previously entered credentials have been cleared. Re-entering them doesn't help.
I can't find much in the way of information relating to this functionality around the web. Hopefully somebody can point me in the right direction or acknowledge that this is a known issue / provide a fix eta.