two fact tables incremental refresh

[powerbiexpert22]

there are two fact tables in my power bi data model , sales_fact and budget_fact

sales_fact data is updated every week 

budget_fact data is updated every month

user want to see updated data  every week in report

what frequency i should set on my budget_fact?

[v-xinruzhu-msft]

Hi,

Thanks for the solution @amitchandak  provided, and i want to offer some more information for user to refer to,

hello @powerbiexpert22 , based on your descriotion, you can set the incremental refersh for the budget_fact, and set its refresh days at 7 days, so that you can improve the performance, you can refer to the following link to know more about the incremental refresh.

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[powerbiexpert22]

Hi @amitchandak , do you mean i should set up incremental refresh poilicy (not archive) on sales_fact for 1 month? 

[amitchandak]

@powerbiexpert22 , as refresh can not happen separate, you can set incremental setting, that too for a month.

In this you you can set