Forum Discussion

hoosha_11's avatar
hoosha_11
Helper I
2 years ago

Date tables/Time intelligence

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!

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

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

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        2 years ago

        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.