topic Re: Power BI API - return unexpexted result in Developer

Power BI API - return unexpexted result

DavidPi — Fri, 20 May 2022 08:21:49 GMT

Hello,

I am trying to use Postman and call Power BI API.

First I call https://login.microsoftonline.com/9b511fda-f0b1-43a5-b06e-1e720f64520a/oauth2/token and received token. That is ok.

Then I call https://api.powerbi.com/v1.0/myorg/groups and recieve this:

{
"@odata.context": "http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups",
"@odata.count": 0,
"value": []
}

Access-Control-Expose-Headers →RequestId

Cache-Control →no-store, must-revalidate, no-cache

Connection →Close

Content-Type →application/json; odata.metadata=minimal

Date →Fri, 20 May 2022 07:17:45 GMT

OData-Version →4.0

Pragma →no-cache

RequestId →dde92e15-0829-4a55-9214-c325dd58a90e

Strict-Transport-Security →max-age=31536000; includeSubDomains

Transfer-Encoding →chunked

Via →Proxy

X-Content-Type-Options →nosniff

X-Frame-Options →deny

home-cluster-uri →https://wabi-north-europe-f-primary-redirect.analysis.windows.net/

request-redirected →true

What is the problem?

When I try to call http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups - I receive time out message.

Thx.

David

Re: Power BI API - return unexpexted result

lbendlin — Sat, 21 May 2022 21:01:14 GMT

please post the actual error message

Re: Power BI API - return unexpexted result

DavidPi — Sun, 22 May 2022 17:21:20 GMT

I call api.powerbi.com and don't receive list of workspaces but only this json:

{
"@odata.context": "http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups",
"@odata.count": 0,
"value": []
}

I try to call directly http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups and receive:

502 Badgateway - The proxy did not receive a valid response in time.

Re: Power BI API - return unexpexted result

lbendlin — Sun, 22 May 2022 18:21:35 GMT

You're supposed to cal the official API at https://api.powerbi.com/v1.0/myorg/groups

Groups - Get Groups - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Do you see the same error message there? Do you maybe not have access to any workspaces in your tenant?

Re: Power BI API - return unexpexted result

DavidPi — Mon, 23 May 2022 08:32:49 GMT

I call official API at https://api.powerbi.com/v1.0/myorg/groups but I receive only this JSON:

{
"@odata.context": "http://wabi-north-europe-f-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups",
"@odata.count": 0,
"value": []
}

If I do not have access to no workspaces I would expect empty list.

Re: Power BI API - return unexpexted result

DavidPi — Mon, 23 May 2022 08:58:33 GMT

I see, maybe thats why @odata.count: 0 - our app don't have permission.

I am going to ask our tenant admins.

Re: Power BI API - return unexpexted result

DavidPi — Mon, 23 May 2022 10:08:41 GMT

Yes, it was problem of permission. I add security group (which contains service principal) as admin to my workspaces and it starts working.

Thank you for your help.

Re: Power BI API - return unexpexted result

lbendlin — Mon, 23 May 2022 11:39:10 GMT

There is another API call "Get Groups as Admin".