Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
tahechadv_2022
Helper II
Helper II

PBI API Rest: endpoints are returning empty values

[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?

1 ACCEPTED SOLUTION
5 REPLIES 5
lbendlin
Super User
Super User

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.

And if it doesnt work?

Then you don't have enough permissions.

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

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors