Forum Discussion
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 ...
Hi Greg_Deckler
I turned it off, published and refreshed, but the visuals in the reports won't load.
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.