Forum Discussion
Separate refresh times Power BI Semantic Model
Good Morning
Is it possible to set up separate refresh times for the tables within my model
I currently need to refresh some of the data within my model on a half hourly basis however there are a few of the tables that are only updated in the data warehouse once per day. Is it possible to set up the refesh so that these tables only update once per day.
I am using Power BI desktop and Microsoft service to publish the model to.
Hi maurcoll
Power BI doesn’t allow different refresh times for individual tables inside a single semantic model, the refresh schedule always applies to the entire dataset. To handle different refresh needs, you can split your model into two datasets: one for fast-refresh tables (like sales or transactions) and another for slow-refresh tables (like reference or master data). Then, schedule the fast dataset to refresh every 30 minutes and the slow one to refresh once per day.
You can also use Dataflows to refresh data separately before loading it into your main model or use DirectQuery for live, frequently changing tables. If needed, you can combine both datasets using a composite model in Power BI Desktop. Finally, publish both models to the Power BI Service and set their refresh frequency independently for smooth, optimized updates.
3 Replies
Hi maurcoll
Power BI doesn’t allow different refresh times for individual tables inside a single semantic model, the refresh schedule always applies to the entire dataset. To handle different refresh needs, you can split your model into two datasets: one for fast-refresh tables (like sales or transactions) and another for slow-refresh tables (like reference or master data). Then, schedule the fast dataset to refresh every 30 minutes and the slow one to refresh once per day.
You can also use Dataflows to refresh data separately before loading it into your main model or use DirectQuery for live, frequently changing tables. If needed, you can combine both datasets using a composite model in Power BI Desktop. Finally, publish both models to the Power BI Service and set their refresh frequency independently for smooth, optimized updates.
Thank you that has helped
Hi maurcoll
This is possible with a Fabric capacity via a data factory pipeline.
Use the Semantic model refresh activity to refresh a Power BI Dataset
