API error using service principal

Anonymous — Wed, 30 Sep 2020 11:22:57 GMT

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.

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.

Re: API error using service principal

Anonymous — Fri, 02 Oct 2020 11:57:40 GMT

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?

Re: API error using service principal

Anonymous — Fri, 13 May 2022 14:18:07 GMT

I have exactly same issue

topic API error using service principal in Developer

API error using service principal

Re: API error using service principal

Re: API error using service principal