How to set an alert on powerbi service ,if a visual is breakdown on report

[Anonymous]

Hi Supprot Team,

How to setup alerts to users when a visual is breakdown on the report(powerbi service workspace)

•  we are using single source for the report which is SSAS Tabular(Live connection).

•  is there any way to setup the alerts in powerbi for this scenerio.

Thanks.

[hackcrr · Accepted solution]

Hi, @Anonymous 

Use the Power BI REST API to query the status of reports and datasets. You can write a script to periodically check the status of visual objects. Integrate with monitoring tools such as Azure Monitor or third-party services such as Datadog or New Relic to track the running status of Power BI reports.
The following is a rough example of a script:

$clientId = "your-client-id"
$clientSecret = "your-client-secret"
$tenantId = "your-tenant-id"
$workspaceId = "your-workspace-id"
$reportId = "your-report-id"

# Get OAuth token
$body = @{
    grant_type    = "client_credentials"
    client_id     = $clientId
    client_secret = $clientSecret
    resource      = "https://analysis.windows.net/powerbi/api"
}
$response = Invoke-RestMethod -Method Post -Uri "https://login.microsoftonline.com/$tenantId/oauth2/token" -ContentType "application/x-www-form-urlencoded" -Body $body
$token = $response.access_token

# Check report status
$headers = @{
    Authorization = "Bearer $token"
}
$reportStatus = Invoke-RestMethod -Method Get -Uri "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/reports/$reportId" -Headers $headers

# Check if the report is accessible
if ($reportStatus -eq $null) {
    # Send alert (email, SMS, etc.)
    Write-Output "Report is not accessible"
} else {
    Write-Output "Report is accessible"
}

Also, you might consider setting up an alert in the dashboard in Power BI Service. Send alerts when your metrics meet the alert criteria.

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