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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
brittaf2002
Frequent Visitor

401 unauthorized response only for a single report when using report pages REST API

Cross posting in case I placed this in the wrong forum. 

 

We have a customer who is getting a 401 unauthorized only for the report pages API using a service principal. 

 

They are successfully able to run these APIs without any issue: 

https://learn.microsoft.com/en-us/rest/api/power-bi/groups/get-groups

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group

and even https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-pages-in-group for one report, but this last API doesn't work for one of the other reports, and the error is the following:

 

 

HTTP error code 401 Unauthorized. 
 {
  "error" : {
    "code" : "PowerBINotAuthorizedException",
    "pbi.error" : {
      "code" : "PowerBINotAuthorizedException",
      "parameters" : { },
      "details" : [ ],
      "exceptionCulprit" : 1
    }
  }
}

 

 

I was not aware of any specific permissions which applies to report pages. Why would we get this error for one particular report? Are there circumstances where we can't query the pages for some reports due to authorization?

 

1 ACCEPTED SOLUTION
brittaf2002
Frequent Visitor

I'll update this in both places I've posted this question. I found the issue and I believe this is a bug in the REST APIs. The issue occurs when the report uses a dataset belonging to a workspace the service principal doesn't have access to. But why the pages api? The reports in group api works fine. Is there anywhere in the documentation that this is explained?

View solution in original post

1 REPLY 1
brittaf2002
Frequent Visitor

I'll update this in both places I've posted this question. I found the issue and I believe this is a bug in the REST APIs. The issue occurs when the report uses a dataset belonging to a workspace the service principal doesn't have access to. But why the pages api? The reports in group api works fine. Is there anywhere in the documentation that this is explained?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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