Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |