How to Run PowerBI REST API in Azure Cloud shell

Question

I'm trying to get the powerbi apps details using the Azure Cloudshell,

Here is the Powershell script i'm using,

$secret="********"
$tenantId="********"
$appId="********"
    
$password= ConvertTo-SecureString $secret -AsPlainText -Force
$credential= New-Object System.Management.Automation.PSCredential ($appId, $password)
    
#Connecting to PowerBI
Connect-PowerBIServiceAccount -ServicePrincipal -Tenant $tenantId -Credential $credential

$accessToken = Get-AzAccessToken

#Get-PowerBIAccessToken
$authHeader = @{    

                    'Content-Type'='application/json'

                    'Authorization'= $accessToken.Authorization

                }

$uri="https://api.powerbi.com/v1.0/myorg/apps/****"

$allapps = (Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET).Value

$allapps.Name

When i'm running this cmd in Azure Cloudshell window, i'm getting bellow error, what could be the problem ? Code with error

I have added the SPN to the PowerBI Tenant settings and have API permission as below Azure API Permission

You have an authentication error with Azure. See following : learn.microsoft.com/en-us/azure/app-service/… — jdweng
– jdweng, Commented Apr 15, 2023 at 14:26
I do not know which authentication mode the server is requiring. Older servers were using Windows Credentials. New servers are requiring OAUTH 2.0. Azure moved from Windows Credentials to OAUTH 2.0 be compatible with Windows, Linux, and MAC. Setting up server will depend on OS. Not sure if issue is with client, server, or both. — jdweng
– jdweng, Commented Apr 17, 2023 at 11:47

Rukmini · Accepted Answer · 2023-05-03 10:12:33Z

0

Note that: To list the Power BI apps, service principal authentication method is not supported.

The error "Invoke-RestMethod : The remote server returned an error: (403) Forbidden" usually occurs if there are no proper permissions to perform the action.

Here, in your scenario the 403 error as you are trying to get apps using service principal authentication.

enter image description here

To resolve the issue, you can make use of below commands:

Make sure to connect to PowerBI with service account.

Connect-PowerBIServiceAccount

$apps= Invoke-PowerBIRestMethod -Url 'apps' -Method Get
$apps

enter image description here

Reference:

Apps - Get App - REST API (Power BI Power BI REST APIs)

answered May 3, 2023 at 10:12

Rukmini

17.7k2 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Run PowerBI REST API in Azure Cloud shell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related