Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,082
Community Members
 
Community Events
168
Community Groups

Can't connect to JIRA with oData in Power BI

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

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

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

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

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

Hi Team,

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

@Harsh Agarwal [AIO] 

Thanks

Venkateshwar

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

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

Atlassian Community Events