Forum Discussion
Helper IVSeparate refresh times Power BI Semantic Model
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.
Super UserHi 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.
Helper IVThank you that has helped