Questions about using the Power BI API

Question

Questions about using the Power BI API

Usuario Datawake 0

Good morning,

I am facing issues using the Power BI API. I have created the service in Azure and granted all the necessary permissions:

JSON

"scope": "UserDataFunction.Read.All Connection.ReadWrite.All Connection.Read.All UserState.ReadWrite.All Workspace.Read.All Workspace.ReadWrite.All Tenant.ReadWrite.All Dataset.ReadWrite.All Dataset.Read.All Dashboard.Read.All Tenant.Read.All App.Read.All Report.Execute.All Dashboard.Reshare.All Dashboard.ReadWrite.All Report.Read.All Report.ReadWrite.All Dashboard.Execute.All Workspace.GitCommit.All Workspace.GitUpdate.All"

When trying to use the endpoint https://api.powerbi.com/v1.0/myorg/groups, the response indicates that there are no groups, even though I have several workspaces and Power BI Pro and PPU licenses:

JSON

"@odata.context": "https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups",
    "@odata.count": 0,
    "value": []

Could you please inform me if there is anything else I need to do?

Usuario Datawake 0

{
    "scope": "UserDataFunction.Read.All Connection.ReadWrite.All Connection.Read.All UserState.ReadWrite.All Workspace.Read.All Workspace.ReadWrite.All Tenant.ReadWrite.All Dataset.ReadWrite.All Dataset.Read.All Dashboard.Read.All Tenant.Read.All App.Read.All Report.Execute.All Dashboard.Reshare.All Dashboard.ReadWrite.All Report.Read.All Report.ReadWrite.All Dashboard.Execute.All Workspace.GitCommit.All Workspace.GitUpdate.All"
}

{
    "@odata.context": "https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups",
    "@odata.count": 0,
    "value": []
}

Usuario Datawake 0 Reputation points

2025-02-06T16:47:48.2433333+00:00

Hi,

I noticed something interesting. I can access the endpoint https://api.powerbi.com/v1.0/myorg/groups/{group_id}/users, but I cannot access the endpoints for reports and datasets users.

I used JWT to decode the token I’m passing and saw that only the permissions roles: [“Tenant.ReadWrite.All”, “Tenant.Read.All”] are being included in the token. According to the documentation, I need permissions for reports and datasets, but I added these permissions under ‘delegated permissions’ because they do not exist under ‘application permissions’. It seems the token only includes application permissions.

Could this be related to my license or a configuration error?

Thank you for your assistance.

1 answer

Your answer

Usuario Datawake 0 Reputation points

2025-02-06T12:45:17.4266667+00:00

{ "scope": "UserDataFunction.Read.All Connection.ReadWrite.All Connection.Read.All UserState.ReadWrite.All Workspace.Read.All Workspace.ReadWrite.All Tenant.ReadWrite.All Dataset.ReadWrite.All Dataset.Read.All Dashboard.Read.All Tenant.Read.All App.Read.All Report.Execute.All Dashboard.Reshare.All Dashboard.ReadWrite.All Report.Read.All Report.ReadWrite.All Dashboard.Execute.All Workspace.GitCommit.All Workspace.GitUpdate.All" }

{ "@odata.context": "https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups", "@odata.count": 0, "value": [] }
Usuario Datawake 0 Reputation points

2025-02-06T16:47:48.2433333+00:00

Hi,

I noticed something interesting. I can access the endpoint https://api.powerbi.com/v1.0/myorg/groups/{group_id}/users, but I cannot access the endpoints for reports and datasets users.

I used JWT to decode the token I’m passing and saw that only the permissions roles: [“Tenant.ReadWrite.All”, “Tenant.Read.All”] are being included in the token. According to the documentation, I need permissions for reports and datasets, but I added these permissions under ‘delegated permissions’ because they do not exist under ‘application permissions’. It seems the token only includes application permissions.

Could this be related to my license or a configuration error?

Thank you for your assistance.

Answer 1

@Usuario Datawake ,

Based on your query, this involves Power BI modeling and handling SCD Type 4 relationships in Power BI.

Currently, Power BI is not supported in Microsoft Q&A forums. We recommend posting your query in the Power BI Community Forum, where experts can assist you better:

Power BI Community Forum: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi

For a list of supported products on Microsoft Q&A, you can refer to this page: Supported products on Microsoft Q&A.

User's image

Hope this helps. Let us know if you have any further queries.

Share via

Questions about using the Power BI API

1 answer

Your answer