Forum Discussion
Anonymous
5 years agoNot applicable
Incremental Refresh - Future values
Hi all, I've setup incremental refresh for the main FACT table in our dataset. This table includes actuals and budget data. THe incremental refresh is working correctly, however for the budg...
- 5 years ago
hi Anonymous
Here is the extract belowAnd what you would need to do is to change the effectiveDate to be the date in the future you want it to go into.
For example if you wanted it to go until the end of 2020 you would change it to the following:
{ "refresh": { "type": "full", "applyRefreshPolicy": true, "effectiveDate": "12/31/2020", "objects": [ { "database": "IR_AdventureWorks", "table": "FactInternetSales" } ] } }
GilbertQ
5 years agoSuper User
Hi there
You are correct in that will apply if you are using Power BI Premium, where you can control it via the XMLA.
If it is in Power BI Pro I do not think that this is possible.
You are correct in that will apply if you are using Power BI Premium, where you can control it via the XMLA.
If it is in Power BI Pro I do not think that this is possible.
Anonymous
5 years agoNot applicable
GilbertQ Yeah thats right. We have premium. Do you know how to apply this? I'm struggling to find where to apply the effective date
- Anonymous5 years agoNot applicable
Hi,
Did you find where to apply these changes?