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?

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?

• c#
• powerbi
• tabular-editor

1 Answer 1

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