Power BI JIRA App connection Stopped working

[Peter Fitzpatrick]

My connection from JIRA to PowerBI was working fine until the 24th June 2019.

Has anything changed on the JIRA side that could caused this?

No error appears and no data being pulled through.

When I try to create a new report with the same parameters, I do not get an option for login detail, but  I get an error:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (Bad Request)"  

Regards

[Daniel Eads · Accepted solution]

Hey Peter,

I've double-checked your site and found that your account is connecting to Jira Cloud with a password over basic authentication. We've deprecated that in favor of API tokens and the change was pushed through at the end of June.

You'll need to switch PowerBI over to using an API token instead of your account's password. The process is documented here, but I've copied and pasted the steps for your convenience:

1. Log in to https://id.atlassian.com/manage/api-tokens.
2. Click Create API token.
3. From the dialog that appears, enter a memorable and concise Label for your token and click Create.
4. Click Copy to clipboard, then paste the token to your script, or elsewhere to save:
   
   

Note:

• For security reasons it isn't possible to view the token after closing the creation dialog; if necessary, create a new token.
• You should store the token securely, just as for any password.

Let me know if you have any more questions!

Cheers,
Daniel | Atlassian Support

[Peter Fitzpatrick]

Thank you Daniel, makes sense.

It took me a while to figure out that I needed to log in with "Basic" credentials, user equals my email address and password is the API token.

Regards

Peter