Can't connect to JIRA with oData in Power BI

Jason Yeung October 5, 2020

Hi,

I've installed the "AIO Power BI Connector for Jira" add-on so I could generate Power BI reports. After installing, I followed the instructions on how to setup the oData link (https://aioreports.atlassian.net/wiki/spaces/APBCFJ/pages/1507450/Application+link+Jira+Hosted+only)

After doing this, I opened Power BI and then attempted to create a oData feed with the URL from the setup page. It seems that no matter which option I picked (e.g. windows / anonymous, any level, etc.) I always get a "we couldn't authenticate with the credential provided" error. 

I was wondering if there is something I need to setup to allow it to be authenticated?

Jason

 

 

2 answers

0 votes
Lemarl S
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 22, 2020

Hi @Jason Yeung ,

Have you been able to find a solution to this? As I seem to be having the same issue on my instance of Jira

Navarambh Software - Gmail
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 22, 2020

Hi,

Please submit a ticket at the link below and we will be happy to take a look.

https://aioreports.atlassian.net/servicedesk/customer/portal/7

 

Regards

AIO Support

Jason Yeung October 22, 2020

Hi @Lemarl S ,

I ended up using Basic authentication. The credentials I entered is the SQL server credentials to connect to the JIRA database.

Sincerly,

Jason

0 votes
Navarambh Software - Gmail
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 5, 2020

Hi,

Thank you for contacting us. We are looking into the ticket raised by you in our ticketing system and will continue to communicate there to resolve the problem that you are facing.

Regards

AIO Support

Venkateshwar Aynala March 31, 2022

Hi Team,

Just interested in knowing if this was ever resolved and if yes please could you share the resolution.

@Navarambh Software - Gmail 

Thanks

Venkateshwar

Lisa Teves {Appfire} April 1, 2022

Hi @Venkateshwar Aynala

Thanks for reaching out! There are no known issues or errors when setting up a URL and generating an OData feed in Power BI. If you're running into an issue, please submit a support ticket and someone from our team will reach out as soon as possible. 

Let me know if I can help further! 

 

Cheers,

Lisa Teves, Product Marketing Manager

Venkateshwar Aynala April 1, 2022

Hi Lisa,

Thanks for the revert. We ran into a similar issue for a user who could not use the connector URL through oData feed in Power BI as it would always throw authentication error.

We have managed to resolve that now. Just so that it helps others we understood that if the password/username being used by user has non-Ascii characters this would be rejected with 401 unauthenticated error. Here's the known bug - https://jira.atlassian.com/browse/JRASERVER-59828.

Thanks

Venkateshwar

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.5.3
TAGS
AUG Leaders

Atlassian Community Events