Power BI Connector for Azure Active Directory

Build 24.0.9062

DirectoryRoleMembers

DirectoryRoleMembers table for Azure AD data provider.

Table Specific Information

Select

Get the members of Directory Roles in your Azure Active Directory. You can filter results by RoleId and UserId.

  • RoleId supports the '=' and IN operators.
  • UserId supports the '=' and IN operators.

For example, the following queries are processed server side:

SELECT * FROM DirectoryRoleMembers WHERE RoleId = '25502c98-94df-43fa-baf7-4a105e200030'

SELECT * FROM DirectoryRoleMembers WHERE UserId IN (SELECT Id FROM Users)

Columns

Name Type Description
RoleId [KEY] String The id of the directoryRole.
UserId [KEY] String The User Id of the user listed.

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