Forum Discussion
Automating Auto Date/Time Configuration for Semantic Model
Hi User2531
There's no tenant setting, Group Policy, or registry key that disables Auto date/time organization-wide. Both Desktop options are local. Global applies only to files created afterwards, Current File only to the open file. So this has to be enforced structurally:- Live connections to a shared model the only true prevention
Report authors connecting live to your enterprise semantic model can't modify the data model, so they never generate Auto date/time tables. Grant Build permission and make thin reports the default pattern.
- PBIP + Best Practice Analyzer in CI/CD, the enforcement point
For teams who need their own models, Microsoft publishes build-pipeline guidance for Power BI projects, and the default BPA rule set includes [Performance] Remove auto-date table, which flags calculated tables named DateTableTemplate_ or LocalDateTable_. Fail the build on that rule and non-compliant models stop before deployment.
- Service remediation (per model)
With write permission on the model: Model view → Switch to Editing mode → File → Options → Time intelligence → Auto date/time.
Two caveats it's per-model with no bulk option, and republishing the PBIX from Desktop overwrites the Service values. Treat it as remediation, not enforcement. Check before flipping it on an established model: removing the hidden tables breaks reports and DAX that reference those hierarchies.
- A standard .pbit template
Useful, but a convention rather than a control it only helps developers who actually start from it.
Finally, mark the enterprise Date table as the model's Date table so time intelligence resolves against it.
In short: central Date table + live connections to shared models + BPA validation in CI/CD + standard templates.
References:
https://learn.microsoft.com/power-bi/guidance/auto-date-time
https://learn.microsoft.com/power-bi/transform-model/desktop-auto-date-time
https://learn.microsoft.com/power-bi/transform-model/service-model-options
https://learn.microsoft.com/power-bi/developer/projects/projects-build-pipelines
https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules
https://learn.microsoft.com/power-bi/guidance/powerbi-implementation-planning-user-tools-devicesThanks,
C Srikanth
Community Support Team
Community SupportHi User2531
There's no tenant setting, Group Policy, or registry key that disables Auto date/time organization-wide. Both Desktop options are local. Global applies only to files created afterwards, Current File only to the open file. So this has to be enforced structurally:
- Live connections to a shared model the only true prevention
Report authors connecting live to your enterprise semantic model can't modify the data model, so they never generate Auto date/time tables. Grant Build permission and make thin reports the default pattern.
- PBIP + Best Practice Analyzer in CI/CD, the enforcement point
For teams who need their own models, Microsoft publishes build-pipeline guidance for Power BI projects, and the default BPA rule set includes [Performance] Remove auto-date table, which flags calculated tables named DateTableTemplate_ or LocalDateTable_. Fail the build on that rule and non-compliant models stop before deployment.
- Service remediation (per model)
With write permission on the model: Model view → Switch to Editing mode → File → Options → Time intelligence → Auto date/time.
Two caveats it's per-model with no bulk option, and republishing the PBIX from Desktop overwrites the Service values. Treat it as remediation, not enforcement. Check before flipping it on an established model: removing the hidden tables breaks reports and DAX that reference those hierarchies.
- A standard .pbit template
Useful, but a convention rather than a control it only helps developers who actually start from it.
Finally, mark the enterprise Date table as the model's Date table so time intelligence resolves against it.
In short: central Date table + live connections to shared models + BPA validation in CI/CD + standard templates.
References:
https://learn.microsoft.com/power-bi/guidance/auto-date-time
https://learn.microsoft.com/power-bi/transform-model/desktop-auto-date-time
https://learn.microsoft.com/power-bi/transform-model/service-model-options
https://learn.microsoft.com/power-bi/developer/projects/projects-build-pipelines
https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules
https://learn.microsoft.com/power-bi/guidance/powerbi-implementation-planning-user-tools-devices
Thanks,
C Srikanth
Community Support Team