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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pdunbar
Regular Visitor

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
Regular Visitor

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
Regular Visitor

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}) 

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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