topic Re: Unauthorized response getting reports through groups endpoint of API in Developer

Unauthorized response getting reports through groups endpoint of API

pangelino — Wed, 15 Nov 2017 23:28:18 GMT

I'm using the Power API REST API to first retrieve groups that the logged in user has access to, and then to retrieve reports within those groups. I can successfully retrieve reports through the https://api.powerbi.com/v1.0/myorg/reports endpoint, but if I make the request through the https://api.powerbi.com/v1.0/myorg/groups/{group_id}/reports endpoint with any of the retrieved group id's, I get a 401 - Unauthorized response. I am sending the access token as an authorization header using the "Bearer {token}" format, the same as when I successfully retrieve reports independent of the group id. Can anyone suggest what the problem is here? Thanks in advance!

Re: Unauthorized response getting reports through groups endpoint of API

Eric_Zhang — Thu, 16 Nov 2017 09:14:04 GMT

@pangelino wrote:

I'm using the Power API REST API to first retrieve groups that the logged in user has access to, and then to retrieve reports within those groups. I can successfully retrieve reports through the https://api.powerbi.com/v1.0/myorg/reports endpoint, but if I make the request through the https://api.powerbi.com/v1.0/myorg/groups/{group_id}/reports endpoint with any of the retrieved group id's, I get a 401 - Unauthorized response. I am sending the access token as an authorization header using the "Bearer {token}" format, the same as when I successfully retrieve reports independent of the group id. Can anyone suggest what the problem is here? Thanks in advance!

@pangelino

Is the registered app with sufficient permissions? You can check the permission in Azure portal->Active Directory->App registrations. The delegated perssions count shall be 14.

Is your account a member of the workspace group?

Re: Unauthorized response getting reports through groups endpoint of API

pangelino — Thu, 16 Nov 2017 17:00:48 GMT

Thanks for your reply @Eric_Zhang. I should have mentioned that when I log into powerbi.com with the same account that I use to test the application, I can navigate through "Workspaces" (groups in the API), and can see and execute reports within them. My application seems to see all the same groups, but is unauthorized to request reports through the groups/{group_id}/reports endpoint.

I have added all the permissions you noted below, even including one Application Permissions that you do not call out. My Azure permissions on the app registration now look like this, but I still get the same 401 Unauthoorized response:

Any other suggestions?

Re: Unauthorized response getting reports through groups endpoint of API

pangelino — Wed, 29 Nov 2017 16:28:45 GMT

@Eric_ZhangI'm still stuck on this. Would you recommend that I open a ticket with technical support on this?

Re: Unauthorized response getting reports through groups endpoint of API

Eric_Zhang — Tue, 05 Dec 2017 07:35:40 GMT

@pangelino

Is the groupid correct? Can you send the accesstoken in your case to me through a private message?

Re: Unauthorized response getting reports through groups endpoint of API

pangelino — Tue, 05 Dec 2017 17:42:58 GMT

Eric, in preparing to reply to you I finally discovered the problem. In my C# code I was sending the HTTP request like this:

HttpWebRequest request = CreatePowerBiApiRequest("groups/{groupId}/reports", accessToken);

What I realized today is that I forgot the $ at the beginning of the string so that the string interpolation would occur. It should have been like this:

HttpWebRequest request = CreatePowerBiApiRequest($"groups/{groupId}/reports", accessToken);

So the request was just statically sending the string "{groupId}" in the request instead of substituting in the actual group ID value. Totally my bad!

Thanks for your help!