Forum Discussion

mp390988's avatar
mp390988
Icon for Post Partisan rankPost Partisan
8 months ago
Solved

Why am I seeing LocalDateTables?

Hi, I am noticing a lot of LocalDateTables showing up in Tabular Model Editor when I connect to my pbix file. I also see a lot of LocalDateTables as TMDL files when I save my report as a pbip. ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 months ago

    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.

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

Those LocalDateTable_* objects are almost always created by Power BI for “auto date/time” style hierarchies behind the scenes.

 

In Desktop, confirm Auto date/time is off in Options → Data Load (both Current File and Global, if applicable), then save and republish.

 

Also keeping thos elocel date tables would increase your model size, thus decreases your rendering and process performance. Disabling this option is the best practice option always.