Export User name and User access into CSV using Power Shell

[ajaquib]

Hi All,

Is it possible to export user name and user access role for a workspace with help of Power shell script.

[amustafa · Accepted solution]

Assuming you are familier with the PowerBI PowerShell cmdlets...

# Import the required module
Import-Module MicrosoftPowerBIMgmt

# Provide your PowerBI credentials
$username = "your_username"
$password = "your_password" | ConvertTo-SecureString -asPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential ($username, $password)

# Connect to PowerBI service account
Connect-PowerBIServiceAccount -Credential $credential | Out-Null

# Get the workspace
$workspace = Get-PowerBIWorkspace -Name "Your Workspace Name" -Scope Organization

# Create an empty array to hold the results
$results = @()

# Loop through each user in the workspace
foreach ($user in $workspace.Users) {
# Create a custom object for each user
$userObj = New-Object PSObject -Property @{
Identifier = $user.Identifier
AccessRight = $user.AccessRight
PrincipalType = $user.PrincipalType
}
# Add the custom object to the results array
$results += $userObj
}

# Export the results to a CSV file
$results | Export-Csv -Path "C:\path\to\yourfile.csv" -NoTypeInformation

# Disconnect from PowerBI service account
Disconnect-PowerBIServiceAccount