Hi @GilbertQ !
Thanks for helping, so i tried and it returns me this error :
Line |
29 | … sResponse = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1 …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Encountered errors when invoking the command: { "code": "PowerBINotAuthorizedException", "pbi.error": {
| "code": "PowerBINotAuthorizedException", "parameters": {}, "details": [], "exceptionCulprit": 1 } }
But i don't know why "PowerBINotAuthorizedException". The security group and the service principal got all the access to PowerBI and permissions in azure/microsoft 365...
Here's my code :
# Authenticate with Service Principal
try {
$secureSecret = ConvertTo-SecureString $clientSecret -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential($clientId, $secureSecret)
Connect-PowerBIServiceAccount
Write-Host "Connected to Power BI Service Account successfully" -ForegroundColor Green
} catch {
Write-Host "Failed to connect to Power BI Service Account: $_" -ForegroundColor Red
exit
}
# Use the Admin API to retrieve all workspaces
try {
$url = "https://api.powerbi.com/v1.0/myorg/admin/groups?\$top=5000"
$workspacesResponse = Invoke-PowerBIRestMethod -Url $url -Method GET
$workspaces = $workspacesResponse.value
Write-Host "Retrieved workspaces successfully" -ForegroundColor Green
$workspaces | Format-Table Id, Name
} catch {
Write-Host "Failed to connect or retrieve workspaces: $_" -ForegroundColor Red
Write-Host "Detail: $_.Exception.Message" -ForegroundColor Red
Disconnect-PowerBIServiceAccount
exit
}
Write-Host "=================================================================================================================================="
Write-Host "Found a total of $($workspaces.Count) workspaces..."
Write-Host "=================================================================================================================================="
So it doesn't happen if i don't put the admin in the url but it will retrieve me only workspaces where the group is (not what i want)..
and with a token :
# Authenticate with Service Principal
try {
$secureSecret = ConvertTo-SecureString $clientSecret -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential($clientId, $secureSecret)
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $tenant
Write-Host "Connected to Power BI Service Account successfully" -ForegroundColor Green
} catch {
Write-Host "Failed to connect to Power BI Service Account: $_" -ForegroundColor Red
exit
}
# Obtain access token using client credentials flow for Power BI API
$body = @{
grant_type = "client_credentials"
client_id = $clientId
client_secret = $clientSecret
scope = "https://analysis.windows.net/powerbi/api/.default"
}
try {
$tokenResponse = Invoke-RestMethod -Method Post -Uri "https://login.microsoftonline.com/$tenant/oauth2/v2.0/token" -ContentType "application/x-www-form-urlencoded" -Body $body
$accessToken = $tokenResponse.access_token
Write-Host "Obtained access token successfully" -ForegroundColor Green
} catch {
Write-Host "Failed to obtain access token: $_" -ForegroundColor Red
exit
}
$headers = @{
Authorization = "Bearer $accessToken"
}
# Retrieve all workspaces using Admin API
try {
$url = "https://api.powerbi.com/v1.0/myorg/groups?\$top=5000"
$workspacesResponse = Invoke-RestMethod -Uri $url -Headers $headers -Method Get
$workspaces = $workspacesResponse.value
Write-Host "Retrieved workspaces successfully" -ForegroundColor Green
$workspaces | Format-Table Id, Name
} catch {
Write-Host "Failed to connect or retrieve workspaces: $_" -ForegroundColor Red
Write-Host "Detail: $_.Exception.Message" -ForegroundColor Red
Disconnect-PowerBIServiceAccount
exit
}
Write-Host "=================================================================================================================================="
Write-Host "Found a total of $($workspaces.Count) workspaces..."
Write-Host "=================================================================================================================================="
Thanks..
Best Regards,
Quentin Michelix.
