Can't connect to JIRA with oData in Power BI

[Jason Yeung]

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

[Lemarl S]

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

[Harsh Agarwal [AIO]]

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]

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

[Harsh Agarwal [AIO]]

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]

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

[Lisa Teves {Appfire}]

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]

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