Skip to main content
Microsoft Idea

Power BI

New

Improve Upon get groups as admin with Expand option

Vote (1) Share
Sam Duval's profile image

Sam Duval on 18 Mar 2022 15:28:32

Trying to use the GET https://api.powerbi.com/v1.0/myorg/admin/groups?$expand={$expand} in power automate, and the API return for at least users, and workspace leaves off "tags" or "elements" if the don't have a value. For example in the users array a group that doesn't have an email address returns this:

 "groupUserAccessRight""Admin",

  "displayName""Power_BI_Admins",

  "identifier""******************",

  "principalType""Group"


if the user has an email it returns with a line for the email

"emailAddress""_***********@**********.com"

 "groupUserAccessRight""Admin",

  "displayName""Power_BI_Admin_With_Emails",

  "identifier""******************",

  "principalType""Group"


it would be a lot easier to ingest the information for reporting purposes if all field elements got returned in the API call and just had blank ("") values

Comments (1)
Sam Duval's profile image Profile Picture

Sam Duval on 18 Mar 2022 15:33:38

RE: Improve Upon get groups as admin with Expand option

suggested api return for no email:"emailAddress": "", "groupUserAccessRight": "Admin",  "displayName": "Power_BI_Admin_With_Emails",  "identifier": "******************",  "principalType": "Group"