Refresh schedule for composite model

Hi BBConsultancy,

When using a composite model with a DirectQuery connection on top of semantic models, the service currently does not provide an option for scheduled refresh, even if there are imported tables. Manual refresh works because it processes the imported data, but automated scheduling isn't available in this configuration.

If you need a rolling date table that updates daily using TODAY(), there are two main options:

Upstream refresh: Host the date table in one of your building blocks, such as an import table in a datamart or dataset. These models support scheduled refresh, so the date table remains current and the composite model accesses it through DirectQuery.

External storage: Store the date table in a source like SQL, OneDrive, or SharePoint (using import mode), which allows you to enable scheduled refresh in your semantic model.

Currently, scheduling refresh on the composite model itself is not supported, so managing refresh upstream is the most dependable solution.

Thank you.