Power BI Connector for SharePoint

Build 21.0.8136


Get Web RoleAssignments.

Table Specific Information


SELECT * FROM RoleAssignments
SELECT * FROM RoleAssignments WHERE List = 'TestApp'
SELECT * FROM RoleAssignments WHERE PrincipalId=5 and list='KatsunariMatsumoto' and ItemId='3'


Name Type References Description
ID [KEY] String The ID of the role assigned.
PrincipalId Long The Principal ID for role assigned.
Updated Datetime The updated date for role assigned.
List String


The internal name of the list to retrieve role assigned from.
ItemId String List item id for role assignment.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8136