cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andyw324 Frequent Visitor
Frequent Visitor

Power BI Report Server - API error

I am having issues with allowing certain "Power Users" access to the Power BI Report Server APIs via URLs. For example when such users try to access https://.../reports/api/v2.0/CatalogItems  they receive the following error:

 

{
  "error":{
    "code":"1251","message":"An error occurred when invoking the authorization extension."
  }
}

And the Power BI Report Server logs return the following error (RSPortal_###.log):

OData exception occurred: Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension.
... stack trace...

Sending response. Response code <Domain\Username> 500...

Our setup use Windows Authentication with RSWindowsNegotiate and RSWindowsNTLM enabled and no custom extensions. When said users are added to the "Administrators" local group on the server hosting Power BI Report Server, the error goes away.

 

We are currently on the August 2018 version of Power BI Report Server sitting on top of SQL Server 2016 (13.0.4224.16).

 

I'm reluctant to add these "Power Users" to the local Administrators group for obvious reasons but this seems to be the only workaround I can see.

 

Strange thing is that the users were able to access the URL fine yesterday and all of a sudden are not able to access today. Also, there have been no reported changes to AD group / user security policies.

 

Any suggestions to what may be the cause of the issue and of any better work arounds would be most welcome.

 

Thanks

 

Andrew

2 REPLIES 2
andyw324 Frequent Visitor
Frequent Visitor

Re: Power BI Report Server - API error

Has anyone else encountered this or shed any light on what may be the cause? The service account does already have delegated authority to pass down credentials so not sure what is the root cause.

 

Is there any way to explicity allow / deny access to the PBIRS / SSRS API?

deepakintel17 New Member
New Member

Re: Power BI Report Server - API error

i too am facing the same issue. In my case also, it suddenly started to throw this error. 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 335 members 3,582 guests
Please welcome our newest community members: