Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
[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?
Solved! Go to Solution.
Described in the Scopes section
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
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?
Described in the Scopes section
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
38 | |
4 | |
4 | |
3 | |
3 |