Forum Discussion

learninggeek_01's avatar
learninggeek_01
Regular Visitor
11 months ago
Solved

Updating Schedule refresh for Power BI Report

Hi, As we know, Schedule refresh for Power BI report could be set manually on the UI. If we are trying to automate the setup of schedule refresh on a report instead of manually entering it, what ar...
@PowerBI Report Server
PowerBI REST API
  • v-achippa's avatar
    v-achippa
    10 months ago

    Hi learninggeek_01,

     

    Cache refresh plans apply only to Paginated reports, not to PBIX reports.
    For power bi(.pbix) reports use Refresh plans, which are managed separately through the Power BI Report Server REST API.

    For your reference below is the official documentation:

    https://learn.microsoft.com/en-us/power-bi/report-server/rest-api

     

    Below is a simple power shell code to create a refresh plan for a PBIX report using the REST API:

    $serverUrl = "https://<your-server>/reports/api/v2.0"
    $reportPath = "/Sales Reports/SalesPerformance"
    $report = Invoke-RestMethod -Uri "$serverUrl/CatalogItems?path=$([uri]::EscapeDataString($reportPath))" -UseDefaultCredentials
    $reportId = $report.value[0].Id

    $body = @{
    "@odata.type" = "#Model.RefreshPlan"
    "Name" = "Daily Refresh"
    "Enabled" = $true
    "StartDate" = (Get-Date "2025-10-14T02:00:00Z")
    "Recurrence" = @{
    "@odata.type" = "#Model.DailyRecurrence"
    "DaysInterval" = 1
    }
    } | ConvertTo-Json -Depth 10

    Invoke-RestMethod -Uri "$serverUrl/CatalogItems($reportId)/RefreshPlans" `
    -Method POST -ContentType "application/json" `
    -UseDefaultCredentials -Body $body

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
11 months ago

Hi learninggeek_01,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Here the failure message appears becuase currently the report has no refreshable external data connections, so there is nothing for the server to refresh. Looks like the report uses a data source type that power bi report server does not support for scheduled refresh. Power BI Report Server supports scheduled refresh for supported PBIX data sources but only when credentials are stored or configured.

 

Power BI Report Server does not support directly editing its internal database tables to add or update schedules. Those tables are internal and manual edits are unsupported and can corrupt encrypted credential data and internal relationships.

To automate creation or updates of refresh schedules, the supported method is to use the Power BI Report Server REST API. For reference, please see below official documents on the Power BI Report Server REST API:

https://learn.microsoft.com/en-us/power-bi/report-server/rest-api

https://learn.microsoft.com/en-us/rest/api/power-bi-report/

 

Thanks and regards,

Anjan Kumar Chippa