To revert from using EffectiveDate to the current date in Tabular Editor 3, follow these steps:
- Modify Calculation Logic – Update DAX expressions to replace EffectiveDate with TODAY() or NOW().
- Adjust Partition Queries – Remove references to EffectiveDate in M Query (Power Query) or SQL partitions and use dynamic date logic instead.
- Update Refresh Policies – In Model > Table Properties > Refresh Policy, disable or modify policies that depend on EffectiveDate, ensuring incremental refresh works correctly.
Best Practices
Validate changes with a test refresh to prevent data issues.
Check for dependencies in measures, calculated columns, and RLS roles.
Monitor performance impact after switching to dynamic date logic.