Forum Discussion
Safely Removing Auto date time created tables
- 3 years ago
Hi, cerebraino ;
As far as I know, there is currently no way to automatically remove safely
Date table;
A convenient way to do this is to save a copy and then delete the date table to see if the original report was affected? If there is no impact, you can delete the table directly;
For how to easily identify whether the report is using this table, you can click on each visual and it will display the table corresponding to the field.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cerebraino , In File -> Option and setting -> Option -> File setting -> data load - disable that - Auto date time intelligence
refer if needed
- cerebraino3 years agoMicrosoft Employee
Actually that video inspired me to find proper ways to remove the automatically created date time tables which in my case are numerous and heavy, the problem is if I go ahead and just change the setting many reports, difficult to know which, out of the 100 will suddenly break annoying many users, therefore I would like to be able to easily know in advance, which reports would break, thanks for your reply!
- Brunner_BI1 year agoImpactful Individual
we added a capability to Measure Killer to detect where you are using hierarchies/fields from Auto Date/time tables recently (version 2.7 and later).