Reload the Model for Specific Tables

[Syndicate_Admin]

Hello

I currently have a data model that consists of 3 fact tables and several dimensions. 2 of the fact tables are records which I need to update during the day, the other fact table keeps historical information for years.

I wanted to know if when scheduling the refresh in power bi services it is possible to make these tables independent, that is, that only the 2 fact tables are reloaded during the day and the remaining one only at night.

Thank you

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

You can try to use dataflow and put specific tables into different dataflows to set a specific time to refresh:

How to refresh only certain tables in power bi ser... - Microsoft Fabric Community

Solved: Dataflows - Only Refresh Specific Tables - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: Create a different schedule refresh for each table... - Microsoft Fabric Community

Solved: Automate Scheduled Refresh of single table in a da... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.