Forum Discussion
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?
Described in the Scopes section
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
5 Replies
- lbendlinSuper 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.
- tahechadv_2022Helper II
And if it doesnt work?
- lbendlinSuper User
Then you don't have enough permissions.