This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hi,
I generated a authorization token via postman.
Then I used this token while calling the groups Rest API: (https://api.powerbi.com/v1.0/myorg/groups)
But the https://api.powerbi.com/v1.0/myorg/groups Rest API call just returns one row. However there are dozens of groups/workspaces in the Power BI environment. What may be the cause of the issue?
Thanks
Solved! Go to Solution.
Hi @innocence84 ,
You can refer the following links to grant the service principal access to the workspaces:
By Powershell:
Add-PowerBIWorkspaceUser (MicrosoftPowerBIMgmt.Workspaces) | Microsoft Learn
Add-PowerBIWorkspaceUser -Scope Organization -Id 23FCBDBD-A979-45D8-B1C8-6D21E0F4BE50 -UserEmailAddress [email protected] -AccessRight Admin
Grant the access in Power BI Service:
Best Regards
Hi @innocence84 ,
As I tested in my side, it can return all workpaces which the account can access to.
Could you please tell me whether the account info used in the below screenshot be granted to all workspaces?
Best Regards
thanks,
I received the client_id and client_secret from Azure Active directory app registration.
You asked: "Could you please tell me whether the account info used in the below screenshot be granted to all workspaces?"
How can I grant the Azure Active Directory app registration for all workspaces?
Hi @innocence84 ,
You can refer the following links to grant the service principal access to the workspaces:
By Powershell:
Add-PowerBIWorkspaceUser (MicrosoftPowerBIMgmt.Workspaces) | Microsoft Learn
Add-PowerBIWorkspaceUser -Scope Organization -Id 23FCBDBD-A979-45D8-B1C8-6D21E0F4BE50 -UserEmailAddress [email protected] -AccessRight Admin
Grant the access in Power BI Service:
Best Regards
Hi again,
I checked Azure portal and Power BI admin portal. I could not find any settings that corresponds an app registration and a Power BI workspace.
Is there any configurating for granting access to a Power BI workspace for the given Azure Active Directory app registration? How should we model analysis like license consumption?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |