CODEWITHSUNDEEP
c#powerbitabular-editor
Christine
Christine

Reputation: 47

Tabular Editor 3: How do I revert from refresh policies with EffectiveDate to using current date?

For dev/testing purposes, I only have data available early January from a Power BI dataflow. Due to that, I applied the refresh policies with EffectiveDate as shown in this Tabular Editor Documentation.

var effectiveDate = new DateTime(2025, 1, 7);  // Todo: replace with your effective date
Selected.Table.ApplyRefreshPolicy(effectiveDate);

After executing this C# script, now I have partitions that cover up to effectiveDate. This is as expected. However, I'm wondering if this execution would continue to override the current date once I promote these changes from the Dev to Prod workspace. How would I revert back to creating partitions up to the current date?

Upvotes: 0

Views: 21

Answers (1)

Christine
Christine

Reputation: 47

Found the solution. We can just reset via this function overload ApplyRefreshPolicy()

Upvotes: 0

Related Questions