Basic Authentication Credentials Error Through Excel Power Query

Question

Hi,

Trying to leverage Power Query in Excel to access a Jira filter as a Web Source using basic authentication. Confirmed the credentials are correct and the URL used as the data source when pasted into a browser downloads the desired CSV.

The query has worked for months previously using the same credentials and source but now I can not resolve the "We couldn't authenticate with the credentials provided. Please try again." error.

Any guidance or ideas would be greatly appreciated, please let me know if any additional information is needed.

Thank you!

Thomas Deiler_db00h3 · Answer

Dear @Ryan O'Donnell ,

can you figure out, if the api token in general works, first? Use Postman and do some

https://***.atlassian.net/rest/api/2/issue/KEY-123

Replace KEY-123 with a real issue key.

You can also use a browser extension like https://restlet.com/modules/client/

So long

Thomas

Ryan O'Donnell · Answer

thanks @Thomas Deiler ! i'm having a lot of trouble trying to get the power query to work even after scouring the site for instructions. i created an API token and have tried to use the 'Web API' data source, pasting the key into the 'Key' line below, but get the error below.. any ideas? may be more of an excel issue at this point...

Thomas Deiler_db00h3 · Answer

Dear @Ryan O'Donnell ,

basic auth is deprecated - use api tokens instead.

So long

Thomas