Scheduled refresh is not enabled

Hii Delex_User1 

If your model is built using API-based loading (push/streaming datasets) or DirectQuery, Scheduled Refresh is automatically disabled in the Service because Power BI does not own the data refresh cycle. In these cases, data is either pushed via API or queried live at report runtime, so there is nothing for Power BI to refresh on a schedule. If you need Scheduled Refresh, the data must be loaded using Import mode with a supported connector and credentials configured in the Service.

When you connect to an API using Power Query and:

• build the URL dynamically (string concatenation, parameters, variables, etc.), or

• use functions like Web.Contents() with a dynamically constructed URL,

Power BI Service treats it as a dynamic data source, and blocks scheduled refresh for security reasons.

Keep the base URL static and move dynamic parts into RelativePath and Query.

Dynamic (breaks refresh):

Web.Contents("https://api.example.com/" & Endpoint)

Supported pattern:

Web.Contents(
    "https://api.example.com",
    [
        RelativePath = "v1/data",
        Query = [ startDate = "2024-01-01", endDate = "2024-12-31" ],
        Headers = [ Authorization = "Bearer xxx" ]
    ]
)

If you’re using:

• DateTime.LocalNow()

• user-defined parameters that change per refresh

• logic that alters the URL

Replace them with:

• fixed parameters, or

• logic inside Query instead of URL concatenation