Forum Discussion

DmitryKrass's avatar
DmitryKrass
New Member
4 years ago
Solved

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...
  • lbendlin's avatar
    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.