Jira connection (cloud) failed source credentials

[bedahl]

Hi,

I am trying to connect to Jira App from powerbi.com. I get the following error:

"Failed to update data source credentials: The credentials provided for the Web source are invalid"

I am using the Authentication method: Basic.

If I use Anonymous, i get the headers with no data.

I know that my cridentials are correct. I have also tried from a college's account. Any tips? 

Best regards,

Benedicte

[bedahl]

Hi,

I am trying to connect to Jira App from powerbi.com. I get the following error:

"Failed to update data source credentials: The credentials provided for the Web source are invalid"

I am using the Authentication method: Basic.

If I use Anonymous, i get the headers with no data.

I know that my cridentials are correct. I have also tried from a college's account. Any tips? 

Best regards,

Benedicte

[v-qiuyu-msft]

Hi @bedahl,

I have tested on my side, it's able to get JIRA content pack successfully. 

In your scenario, please ensure it's cloud JIRA repository not a on-premise one since the latter will not work with the JIRA content pack. 

You could test with JIRA pbit file use the same JIRA URL and credential to see if you are able to get data successfully. 

Best Regards,
Qiuyun Yu

 

[bedahl]

Hi @v-qiuyu-msft,

Thank you for your quick reply. I have tried this without success. In the pbit file I only get headers due to Anonymous authentication . When I edit to Basic authentication in the published dataset and write my user name and password, I'm getting the same error: 

[v-qiuyu-msft]

Hi @bedahl,

Do you indeed connect to JIRA online instance instead of on-premise one? 

When you open the pbix file in Power BI desktop, please use Basic credential, see: 

Best Regards,
Qiuyun Yu 

[bedahl]

@v-qiuyu-msft Thank you for your support. 

No luck yet.. I will let you know if I manage to solve it.

Best regards,

Benedicte

[Anonymous]

Hiya, I'm bringing this topic back to life, have the same issue as the OP, have JIRA in the Cloud, I already have user stories configured and active in JIRA, so I know the credentials work, but still get the exact same error. Can't seem to be able to download the .pbit file anymore (the link doesn't point to a file) so I'm kind of stuck, any help would be highly appreciated. Thank you. Adrian

[Anonymous]

Hi, I'm having exactly the same issue as mentioned by adicristea and the OP.

If I log into my Jira accounts (yes, I can confirm that my credentials are correct), using the web browser I can access into https://******.atlassian.net/rest/api/2/search and see the first page of the JSON data.

But if I try to login from Power BI, I get the following error:

I've checked with Fiddler and I get 401 response code in the requests. From the browser, like I said it works fine.

[Anonymous]

I am having the same issue. Have there been any updates on this issue? 

[pchemes]

Hi, same issue. Using Jira Cloud, I get authentication error when using basic, and my credentials works fine in the browser.  Thanks.

[Anonymous]

I found a solution to my previous comment and this thread. Please upvote it as a solution so it's displayed at the top.

Atlassian discontinued the basic authentication using email + password, but it's possible to log in using an API token.

Steps:

1. Log into Jira and go to https://id.atlassian.com/manage/api-tokens
2. Generate a new token and give it any name you like. Copy it (once it is generated and saved, it cannot be viewed again. If you forget it, you'll have to create a new one).
3. In power BI, paste the generated token in place of the password, in the "Basic authentication" tab.

The connection will be sucessful now.