Forum Discussion
Incremental Refresh: Backfill?
So I am looking into implementing incremental refresh for our data models. Our models are usually linear except when we add a new client, because we backfill their Sales data for the last couple years into our database. How would this work with incremental refresh? Would i need to turn it off and publish a version without the refresh to pull the older data in? Change the parameters so it pulls in a larger range? Also, any tips/warnings about incremental refresh would be appreciated.
Tagoad I have a similar situation for one of my clients where they backfill the data when they do so, they do the full refresh, they are using Power BI premium and can use XMLA to force the full refresh. If you are not using Power BI premium, you have to manually force the full refresh by republishing your pbix file, no need to change anything, just publish the pbix file and then do the refresh in Power BI service and it will force the full refresh.
If you have Premium then you can do a full refresh using XMLA.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
Tagoad I have a similar situation for one of my clients where they backfill the data when they do so, they do the full refresh, they are using Power BI premium and can use XMLA to force the full refresh. If you are not using Power BI premium, you have to manually force the full refresh by republishing your pbix file, no need to change anything, just publish the pbix file and then do the refresh in Power BI service and it will force the full refresh.
If you have Premium then you can do a full refresh using XMLA.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
ok thanks! so if I'm understanding this right, after publishing a dataset, the next refresh will be always be a full refresh?
Tagoad that's true and exactly what it is.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
