Forum Discussion
two fact tables incremental refresh
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...
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.