Power BI Connector for Microsoft SharePoint

Build 24.0.9062

RoleDefinitionBindings

Get Web Role definition binding.

Table Specific Information

Select

NOTE: PrincipalId is required to return RoleDefinitionBindings.

SELECT * FROM RoleDefinitionBindings WHERE PrincipalId = 3
SELECT * FROM RoleDefinitionBindings WHERE List = 'TestApp' AND PrincipalId = 3
SELECT * FROM RoleDefinitionBindings WHERE PrincipalId = 5 AND list = 'KatsunariMatsumoto' AND ItemId = '3'

Columns

Name Type References Description
ID [KEY] Int The ID of the role assigned member.
PrincipalId [KEY] Int

RoleAssignments.PrincipalId

The Principal Id.
BasePermissions_High Long The base permissions high.
BasePermissions_Low Long The base permissions low.
Description String The description.
Hidden Boolean A Boolean indicating if it is hidden.
Name String The name.
Order Int The order.
RoleTypeKind Int The role type kind.
List String

Lists.Title

The internal name of the list to retrieve role assigned member from.
ItemId Int List item id for role defintion.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062