PowerBI can no longer connect now that I have to use the API Token

[Jason Coan]

I had Power BI working with our Jira (Cloud), it worked fine for many months.  Now authentication fails, which I assume is due to Atlassian now requiring the API tokens for API access.

I changed the Data Source Settings within Power BI to Web API, and supplied my key.

In the web.contents line of my Power BI code, I added ApiKeyName=<API token label>, as shown below.  

I've tried various other changes, authentication methods, etc.  Nothing else has worked, and this is the only solution that doesn't generate errors, so I think I must be getting close...maybe.  On the API token page, it still shows Last Accessed = never, so it doesn't appear that I'm successful in getting the token authenticated.

Has anybody else been able to get Power BI connected to Jira (cloud) using an API token?  If so, how?  

Power BI code:

contents = Web.Contents("https://sitename.atlassian.com/rest/api/2/search",[
Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)],
ApiKeyName="xxxxxxxx"
]),
json = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)