topic Re: PBI API Rest: endpoints are returning empty values in Developer

PBI API Rest: endpoints are returning empty values

tahechadv_2022 — Mon, 26 Aug 2024 15:33:45 GMT

[Python code]

base_url = 'https://api.powerbi.com/v1.0/myorg/'
header = {'Authorization': f'Bearer {access_token}'}
dedicated_groups = 'groups'
groups = requests.get(base_url + dedicated_groups, headers=header)

try:
    groups = json.loads(groups.content)
    print(json.dumps(groups, indent=4, sort_keys=True))
except Exception as e:
    print('\nRequest failed:', e)

pd.concat([pd.json_normalize(x) for x in groups['value']])

And it returns:

<Response [200]> 
{ 
"@odata.context": "https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups", 
"@odata.count": 0, 
"value": [] 
}

This problem occurs in multiple endpoints, get_dashboards.

But it works in the get_capacities endpoint.

Background:

I have the admin account called "dados", under this account I have the account "dashboards".

All of my dashboards are hosted in the "dashboards" account spread throughtout 4 workspaces (groups).

All of the access were granted to both accounts in the PBI Admin portal, both for workspaces and dashboards. Also in the Admin Portal was granted access to the API.

Can someone help me?

Re: PBI API Rest: endpoints are returning empty values

lbendlin — Mon, 26 Aug 2024 18:31:50 GMT

Run your request in the sandbox first.

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

See if you get data there.

Re: PBI API Rest: endpoints are returning empty values

tahechadv_2022 — Mon, 26 Aug 2024 19:52:25 GMT

And if it doesnt work?

Re: PBI API Rest: endpoints are returning empty values

lbendlin — Mon, 26 Aug 2024 20:02:36 GMT

Then you don't have enough permissions.

Re: PBI API Rest: endpoints are returning empty values

tahechadv_2022 — Mon, 26 Aug 2024 20:47:50 GMT

What are the permissions required beyond the API (admin portal), workspaces and dashboards?

Re: PBI API Rest: endpoints are returning empty values

lbendlin — Mon, 26 Aug 2024 20:56:48 GMT

Described in the Scopes section

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn