Forum Discussion
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.
Thank you for the clarification. The DAX solution won't work unfortunately because my date table would use a TODAY() function. I don't want (and need) future dates in my model to make SPLY measures simpler.
It's still weird though that the service does not let you set a refresh schedule when one or more tables in the model are defined as 'Import'.
Maybe adding a DAX calculated table to one of the building blocks will work, because they are on import mode with a refresh schedule.
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.