Forum Discussion
DmitryKrass
4 years agoNew Member
Wipe certain data before new load
Hello Team, I have forecasting table in my data model (year-month, material code, qty) which we receive every month. Each time before loading next forecasting file I need clear in the existing forec...
- 4 years ago
Create Incremental refresh with monthly partitions. Disable automatic refresh. Swap your data source but keep its name. Manually refresh the partitions you are interested in (via API call).
Note: This will not survive a rogue full dataset refresh. Power BI has no memory, and no concept of global variables. You may need to do all that in the upstream system instead.
lbendlin
4 years agoSuper User
Create Incremental refresh with monthly partitions. Disable automatic refresh. Swap your data source but keep its name. Manually refresh the partitions you are interested in (via API call).
Note: This will not survive a rogue full dataset refresh. Power BI has no memory, and no concept of global variables. You may need to do all that in the upstream system instead.