cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daamruth
Advocate I
Advocate I

Power BI Premium: Incremental Refresh of future dates

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 

2 REPLIES 2
lbendlin
Super User
Super User

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".

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). 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors