Gateways - Add Datasource User

  • Reference
Service:
Power BI REST APIs
API Version:
v1.0

Grants or updates the permissions required to use the specified data source for the specified user.

Permissions

The user must have gateway admin permissions.

Required Scope

Dataset.ReadWrite.All

Limitations

Virtual network (VNet) gateways aren't supported. Adding groups through the API is not supported. 

POST https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources/{datasourceId}/users

URI Parameters

Name In Required Type Description
datasourceId
 path True

string

uuid

The data source ID
gatewayId
 path True

string

uuid

The gateway ID. When using a gateway cluster, the gateway ID refers to the primary (first) gateway in the cluster. In such cases, gateway ID is similar to gateway cluster ID.

Request Body

Name Required Type Description
datasourceAccessRight True

DatasourceUserAccessRight

The access right (permission level) that a user has on the data source
displayName

string

The display name of the principal
emailAddress

string

The email address of the user
identifier

string

The object ID of the principal
principalType

PrincipalType

The principal type
profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

Responses

Name Type Description
200 OK

OK

Examples

Assign the ReadOverrideEffectiveIdentity user access right to a service principal example
Example

Assign the ReadOverrideEffectiveIdentity user access right to a service principal example

Sample request

POST https://api.powerbi.com/v1.0/myorg/gateways/1f69e798-5852-4fdd-ab01-33bb14b6e934/datasources/252b9de8-d915-4788-aaeb-ec8c2395f970/users
Request Body
{
  "identifier": "3d9b93c6-7b6d-4801-a491-1738910904fd",
  "datasourceAccessRight": "ReadOverrideEffectiveIdentity"
}

Sample response

Status code:
200

Example

Sample request

POST https://api.powerbi.com/v1.0/myorg/gateways/1f69e798-5852-4fdd-ab01-33bb14b6e934/datasources/252b9de8-d915-4788-aaeb-ec8c2395f970/users
Request Body
{
  "emailAddress": "john@contoso.com",
  "datasourceAccessRight": "Read"
}

Sample response

Status code:
200

Definitions

Name Description
DatasourceUser

A Power BI user with access to the data source
DatasourceUserAccessRight

The access right (permission level) that a user has on the data source
PrincipalType

The principal type
ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

DatasourceUser

A Power BI user with access to the data source

Name Type Description
datasourceAccessRight

DatasourceUserAccessRight

The access right (permission level) that a user has on the data source
displayName

string

The display name of the principal
emailAddress

string

The email address of the user
identifier

string

The object ID of the principal
principalType

PrincipalType

The principal type
profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

DatasourceUserAccessRight

The access right (permission level) that a user has on the data source

Name Type Description
None

string

No permission to access the data source. Only applies when updating user permissions.
Read

string

Datasets owned by the user have read access to the data source
ReadOverrideEffectiveIdentity

string

The user can override the effective identity for Power BI Embedded. Applicable only for on-premises Analysis Services data sources.

PrincipalType

The principal type

Name Type Description
App

string

Service principal type
Group

string

Group principal type
None

string

No principal type. Use for whole organization level access.
User

string

User principal type

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

Name Type Description
displayName

string

The service principal profile name
id

string

The service principal profile ID