Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
Solved! Go to Solution.
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?
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
6 | |
2 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
4 |