Power BI Premium: Incremental Refresh of future dates

[daamruth]

Dear all, 

we have the same scenario as found here: https://community.powerbi.com/t5/Service/Incremental-Refresh-Future-values/m-p/1394120#M109584

We have budget data reaching out to 2022 atm. 

I can connect to PBI via SSMS and fire that XMLA

{
"refresh": {
"type": "automatic",
"applyRefreshPolicy": false,
"effectiveDate": "12/31/2022",
"objects": [
{
"database": "Sales Cube",
"table": "Sales and OE"
      }
    ]
  }
}

By that I get partitions for the future, in this case until 2022. 

But with every normally "schedule refresh" the before created partitions are deleted and it does a full refresh. 

So my question is: How do I refresh the cube every morning in an incremental manner but  keeping my "future" partitions available? 

I tried to connect via SSIS and execute an XMLA but I do not even get the connection up and running. 

XMLA-Endpoints ReadWrite enabled. 

POwer BI Premium Per User

Thanks a lot for your ideas. 

Daniel 

[lbendlin]

They didn't consider your scenario when they implemented incremental refresh.

Use a different date in your source data to drive the partitions, for example "Last modified Date".

[daamruth]

Hi @lbendlin , 

thanks for your reply. Another unpleasant surprise of Power BI 😞 

If I use the "Last modified Date" and I update data e.g. from 2019 how will the old data portion be deleted? Or you mean using detect data changes? 

Thanks a lot

Daniel 

P.S.: If anyone has another idea I am greatful for input (e.g. how to use a refresh via SSIS).