Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.