Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
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.
Hi @amitchandak , do you mean i should set up incremental refresh poilicy (not archive) on sales_fact for 1 month?
@powerbiexpert22 , as refresh can not happen separate, you can set incremental setting, that too for a month.
In this you you can set
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |