Failed to automate the PowerShell script using service principal

[Anonymous]

Hello All,

Daily I want to automate the Powershell script for extracting Power BI tiles in all Dashboards using service principal. After running i am getting the below error. Can anyone please help me to run it.

PowerShell script i am using to extract Power BI tiles

$AppId = "Application ID"
$TenantId = "Tenant ID"
$ClientSecret = "Application password"

#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

$Dashboards = Get-PowerBIDashboard -scope Organization
$Tiles =
ForEach ($Dashboard in $Dashboards)
{
Write-Host $Dashboard.Name
ForEach ($Tile in (Get-PowerBITile -DashboardId $Dashboard.Id))
{
[pscustomobject]@{
DashboardID = $Dashboard.Id
DashboardName = $Dashboard.Name
ReportID=$tile.ReportId
}
}
}
$Tiles

Error message:

To know the error details i am running the command (Resolve-PowerBIError) i got the below error:

[aj1973 · Accepted solution]

Hi @Anonymous 

Most likely you are missing the -Scope Organization to access to all dashboards as Admin.

[ibarrau]

Hi. There are different steps we can validate for this. I think most of them are explained in the replies of this recent post: https://community.fabric.microsoft.com/t5/Service/Recieving-403-Forbidden-when-Accessing-Dataset-via...

The only difference with your scenario is that the permissions involved are related to dashboards. Like: "Dashboard.ReadWrite.All and Dashboard.Read.All"

I hope that helps, if you can doubts please feel free to ask again and we can discuss reply by reply of the other post.