Forum Discussion
What will break if I remove the hidden LocalDateTables?
So I decided to make a copy of the original file and do a test.
I turned off the auto date/time under options and here is what happened.
The PBIX file shrunk from 150 to only 17 MB - quite a decrease!
All the calculated columns where I used a variance of the date value (like Dates[Date].[Year] or Dates[Date].[MonthNo]) broke with
the error message:
Luckily, this is pretty easy to solve by switching to the functions Year, Month etc. (like YEAR (Dates[Date]))
Nothing else seems to have broken. I will test further over the next week to see if the copy file starts to look or behave differently than the original one.
So I decided to make a copy of the original file and do a test.
I turned off the auto date/time under options and here is what happened.
The PBIX file shrunk from 150 to only 17 MB - quite a decrease!
All the calculated columns where I used a variance of the date value (like Dates[Date].[Year] or Dates[Date].[MonthNo]) broke with
the error message:
Luckily, this is pretty easy to solve by switching to the functions Year, Month etc. (like YEAR (Dates[Date]))
Nothing else seems to have broken. I will test further over the next week to see if the copy file starts to look or behave differently than the original one.