Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi. I'm trying to automate PowerBI report deployment and actions related with that. Due to organization policy I have to use service principal. The service principal access in PowerBI is enabled and security group with created SP as a member is added. I set created SP as an admin of workspace. The following permissions for AAD app have been granted: User.Read, Content.Create, Dashboard.ReadWrite.All, Dataset.ReadWrite.All, Gateway.ReadWrite.All, Report.ReadWrite.All, Report.ReadWrite.All. When I'm using PowerBI cmdlets for Powershell everything looks fine, eg. the following code is working as expect.
$secret = $ClientKey | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential($ApplicationId, $secret)
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $TenantId
[...]
Remove-PowerBIReport -Id $ReportToDelete.Id -WorkspaceId $Workspace.Id
But when I'm trying to do the same using Invoke-PowerBIRestMethod or Rest API sth is wrong:
$secret = $ClientKey | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential($ApplicationId, $secret)
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $credential -TenantId $TenantId
$Headers = Get-PowerBIAccessToken
[...]
$Uri = 'https://api.powerbi.com/v1.0/myorg/reports/'+ $ReportToDelete.Id
Invoke-PowerBIRestMethod -Url $Uri -Method Delete
or
Invoke-RestMethod -Uri $Uri -Headers $Headers -Method Delete
Error for Invoke-PowerBIRestMethod: "One or more errors occurred. (Response status code does not indicate success: 403 (Forbidden).)"
Error for Invoke-RestMethod: "API is not accessible for application"
Do you have any ideas what's going on and what can be a problem? I need to use Rest API because PowerBI cmdlets for Powershell are not enough.
I have exactly same issue
It looks like the permissions issue. All the permissions granted in AAD I specified above. All the tenant permission in Power Bi Admin Portal are applied for the entire organization. What can be missing?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |