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
"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.
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
P.S.: If anyone has another idea I am greatful for input (e.g. how to use a refresh via SSIS).
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.