Run Get-PowerBIActivityEvent with Service Principal

aaldo_666 — Mon, 26 Sep 2022 15:59:20 GMT

Hi,

I registered app in AAD and enabled Service Principal option in Power BI Admin portal.

So far I can run this cmd let:

$AppId = "AppId"
$TenantId = "TenantId"
$ClientSecret = "ClientSecret"

#Create secure string & credential for application id and client secret
$PbiSecurePassword = ConvertTo-SecureString $ClientSecret -Force -AsPlainText
$PbiCredential = New-Object Management.Automation.PSCredential($AppId, $PbiSecurePassword)

#Connect to the Power BI service
Connect-PowerBIServiceAccount -ServicePrincipal -TenantId $TenantId -Credential $PbiCredential

Get-PowerBIWorkspace -first 5
Get-PowerBIReport -WorkspaceId 666
Get-PowerBIDataset -WorkspaceId 666

AAD app permissions:

But Im not able to run any of MicrosoftPowerBIMgmt.Admin cmd lets. Im expecially interested in Get-PowerBIActivityEvent.

I can run Get-PowerBIActivityEvent with my credentials, but for automation I wanted to use service principal.

Any idea what permissions is service principal missing?

My goal it to run automatically from win scheduler:

Get-PowerBIActivityEvent -StartDateTime $start_day -EndDateTime $end_day

Thanks.

Re: Run Get-PowerBIActivityEvent with Service Principal

v-chenwuz-msft — Tue, 27 Sep 2022 07:21:27 GMT

Hi @aaldo_666 ,

Maybe you can refer this guide:

Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Run Get-PowerBIActivityEvent with Service Principal in Developer

Run Get-PowerBIActivityEvent with Service Principal

Re: Run Get-PowerBIActivityEvent with Service Principal