cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

API error using service principal

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.

1 REPLY 1
Highlighted
Frequent Visitor

Re: API error using service principal

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?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!