Date tables/Time intelligence

[hoosha_11]

Hi,

I noticed that we have 25 date tables (called "LocalDateTable") which I believe are related to time intelligence. In DAX Studio's VertiPaq Analyzer, I observed large sizes between these date columns and other columns in different tables within the Relationships section. This significantly affects memory usage during refresh.

These Date tables are only visible in Analysis Services and not in the Power BI data model.

Is there anything I can do to ignore these tables during the refresh process? I think they are eating memory, and I haven't been able to address the issue yet.

Thanks!

[Greg_Deckler]

@hoosha_11 Turn off auto-time intelligence. File | Options and settings | Options | CURRENT FILE | Data Load | Time Intelligence | Auto date/time. Turn that off.

[hoosha_11]

Hi @Greg_Deckler 

I turned it off, published and refreshed, but the visuals in the reports won't load. 

[Greg_Deckler]

@hoosha_11 Well, if you used auto-time intelligence in something then that could cause a problem. Auto TI syntax is like [Date].[Month]. It's the .[Month] part that is how the underlying tables are referenced. So, you need to get rid of those and just use MONTH([Date]) for example.

Also, if you used the Date Hierarchy in a visual versus just the Date then that would also cause problems.