can't extract users email address from power bi workspace

[pravind96]

I have tried export user workspace details by using Powershell script and also tried manually export the list from admin portal power bi. Both excel list does not contain the users email addresss. How do I extract their email address ? Is there any other way ? I have to look up which email address belongs to which person.

[Jayendran · Accepted solution]

Hi @pravind96 

All you have to use a different powershell to invoke the PBI REST API directly 

$workspacename =""

$workspace =Get-PowerBIWorkspace -Name $workspacename 
 
# GetDataSets 
$UserResponse=Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/users" -Method Get

This will give you the Email of the users

Sample Response

{
"@odata.context":"http://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/groups/xxxxxxxx/$metadata#users","value":[
{
"emailAddress":"Jayendran@abc.com","groupUserAccessRight":"Admin","displayName":"Jayendran Arumugam","identifier":"Jayendran@abc.com","principalType":"User"

}

]

}