cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pdunbar
New Member

Power BI REST API "An error occurred when invoking the authorization extension."

All;

 

I am facing this issue when trying to use some REST API contexts on our Power BI On-Premises instance. 

 

Using : https://servername/reports/api/v2.0/folders

 we receive this error in the server's response. 

{

  "error":{

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

  }

}

 

I suspect it is a permissions error because it works for admins, but no longer for users. I have yet to uncover where the problem lies. 

 

This works as expected and servers up the available contexts for all users
https://servername/reports/api/v2.0/

 

I am hoping you have some guidance or suggestion. 

 

Thank you cordially

 

1 ACCEPTED SOLUTION

Thank you for that information. 

 

I went thourgh it and it didn't solve my issue. 

 

I put users are the 'root' or top level and no change was made. 

 

I did stumble on this though.

 

When I use the API and add a ItemID I get a valid result. 

 

https://servername/reports/api/v2.0/folders({id}) 

View solution in original post

6 REPLIES 6
pdunbar
New Member

I just realized I made a mistake in my request for support... 

 

the URL should read more like 

 

This works as expected and servers up the available contexts for all users
https://servername/reports/api/v2.0/folders 

pdunbar
New Member

Janey;

Thank you for your reply.

 

We use the api to get a list of all the folders in our Power BI instance. As it stands, only server admins can access the data the api should provide.

 

It is not really a valid option to grant power users administrative privileges

 

Is there some server permission or role I need to assign users to inorder for them to access the the api data?

Hi, @pdunbar 

 

Not sure if it is a permission problem, have you tried to give users other permissions, such as browser?

v-janeyg-msft_0-1623133140836.png

Reference:Role definitions - predefined roles - SQL Server Reporting Services (SSRS) | Microsoft Docs

If it doesn't solve your problem, Please feel free to ask me.

 

Best Regards

Janey Guo

 

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

Thank you for that information. 

 

I went thourgh it and it didn't solve my issue. 

 

I put users are the 'root' or top level and no change was made. 

 

I did stumble on this though.

 

When I use the API and add a ItemID I get a valid result. 

 

https://servername/reports/api/v2.0/folders({id}) 

View solution in original post

Hi, @pdunbar 

 

It should be an error in the syntax of powerbi rest api at the beginning, I am glad you can solve it😀, so you can mark your answer as solution to help others.

 

Best Regards

Janey Guo

v-janeyg-msft
Community Support
Community Support

Hi, @pdunbar 

 

Not very clear about your question. I can't reproduce your scene. What did you do with this api url? 

 

Best Regards

Janey Guo

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.