Forum Discussion
Why am I seeing LocalDateTables?
Hi mp390988 ,
Thank you for reaching out to the Microsoft Fabric Community Forum and for confirming Auto date/time is off . Also thank you Tahreem24 and cengizhanarslan for your helpful response.
The behavior you’re seeing is expected. Even when Auto date/time is turned off, Power BI does not remove LocalDateTable_ objects that were created earlier in the model’s lifecycle*. These tables can still appear in Tabular Editor and PBIP/TMDL files, although they remain hidden and are not used by visuals or DirectQuery queries.
Disabling Auto date/time only prevents new local date tables from being generated. It does not retroactively clean up existing system-generated artifacts.
If you want to eliminate them entirely, the only supported approach is to recreate the model in a new PBIX with Auto date/time disabled from the start. Otherwise, they can be safely ignored and will not impact report results or performance.
Thank you.
I confirm the Auto date/time is off (did also mention that in my OP).
Hi mp390988 ,
Thank you for reaching out to the Microsoft Fabric Community Forum and for confirming Auto date/time is off . Also thank you Tahreem24 and cengizhanarslan for your helpful response.
The behavior you’re seeing is expected. Even when Auto date/time is turned off, Power BI does not remove LocalDateTable_ objects that were created earlier in the model’s lifecycle*. These tables can still appear in Tabular Editor and PBIP/TMDL files, although they remain hidden and are not used by visuals or DirectQuery queries.
Disabling Auto date/time only prevents new local date tables from being generated. It does not retroactively clean up existing system-generated artifacts.
If you want to eliminate them entirely, the only supported approach is to recreate the model in a new PBIX with Auto date/time disabled from the start. Otherwise, they can be safely ignored and will not impact report results or performance.
Thank you.