Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mbielby
Helper I
Helper I

Pull data from a REST API Authentication - JIRA

HI , I'm trying to connect PowerBI to the JIRA REST API.  I am receiving the message "Details: "The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer""  My connection settings look like this: 2019-04-05_16h42_13.png

 

The same URL is working OK with POSTMAN using Basic Authentication.  I've seen a few similar posts on the forum but nothing has works for me as yet.    Thanks

1 ACCEPTED SOLUTION
mbielby
Helper I
Helper I

Problem solved.   This was an issue with cached credentials. The fix was to apply a cache clear as recommended by 

hekaplas
hekaplas New Member
New Member
Re: Power BI Web cached credentials For OData

 

 Found a way to remove the cached credentials. In Power BI Desktop select File, Options and Settings and then Data Source Settings. Find the data source with the cached settings and use the "Clear Permissions" button to reset. Again, it should be obvious to the user when cached credentials are used and which cached credentials are used. Even in the Data Source Settings form we can't tell which credentials are used with each data source.

View solution in original post

2 REPLIES 2

Hi @mbielby 

I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.

We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.

Cheers!

Anton

===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mbielby
Helper I
Helper I

Problem solved.   This was an issue with cached credentials. The fix was to apply a cache clear as recommended by 

hekaplas
hekaplas New Member
New Member
Re: Power BI Web cached credentials For OData

 

 Found a way to remove the cached credentials. In Power BI Desktop select File, Options and Settings and then Data Source Settings. Find the data source with the cached settings and use the "Clear Permissions" button to reset. Again, it should be obvious to the user when cached credentials are used and which cached credentials are used. Even in the Data Source Settings form we can't tell which credentials are used with each data source.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.