topic Re: Power BI Token Generation in Developer

Power BI Token Generation

innocence84 — Mon, 21 Aug 2023 03:30:27 GMT

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

Re: Power BI Token Generation

innocence84 — Tue, 22 Aug 2023 05:57:06 GMT

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?

Re: Power BI Token Generation

Anonymous — Wed, 23 Aug 2023 05:33:15 GMT

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

Re: Power BI Token Generation

innocence84 — Wed, 23 Aug 2023 07:05:20 GMT

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?

Re: Power BI Token Generation

Anonymous — Tue, 29 Aug 2023 09:40:40 GMT

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 john@contoso.com -AccessRight Admin

Grant the access in Power BI Service:

Enable workspace access

Best Regards