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.
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 budget numbers it filters all the future values out of the dataset. For example: We have budget numbers for the entire year, when I setup the incremental refresh it only brings in values up to year to date.
How do I change the settings for incremental refresh to include budget numbers for the full year? I see in the documentation about effective date but I don't where/how to apply this settings to the incremental refresh.
Any help would be great.
Thanks
Solved! Go to Solution.
hi @Anonymous
Here is the extract below
And 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 thank you for the reply. In the documentation it talks about using effective date to pull future values out. Do you know how I can use this?
"effectiveDate – If an incremental refresh policy is being applied, it needs to know the current date to determine rolling window ranges for the historical range and the incremental range. The effectiveDate parameter allows you to override the current date. This is useful for testing, demos, and business scenarios where data is incrementally refreshed up to a date in the past or the future (for example, budgets in the future). The default value is the current date."
hi @Anonymous
Here is the extract below
And 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"
}
]
}
}
Ah I should've read the documentation properly. I had to create a new script then copy and paste the effective code and execute.
Got it working. Thank you
@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
Hi,
Did you find where to apply these changes?
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.
User | Count |
---|---|
55 | |
25 | |
19 | |
15 | |
10 |