Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AndyHermle
Helper I
Helper I

Marking as a date table works but Setting 'auto date/time' is still checked in the Options Setting

Dear Experts: 

 

When I mark a Date table as 'Mark as Date table' in Power BI, it removes the auto-generated date hierarchies and the hidden date tables associated with them.

I tried it out and it worked, but what stunned me that the auto date/time option is still checked under the Options Settings for the Current File. I thought this setting would be unchecked automatically when I mark a date table as 'Mark as a date table'.

 

Now here comes my question: If I want to reduce the model size, unchecking this option 'auto date/time' for the current file won't have any effect since the hidden tables have already been removed with this 'Mark as Date Table' Setting.

Am I getting this right?

Help is very much appreciated. Thank you very much in advance

Best Regards, Andreas

1 ACCEPTED SOLUTION
AmiraBedh
Super User
Super User

When you mark a table as a date table, Power BI stops generating hidden date tables and hierarchies for that specific table. This helps reduce the model size and improves performance by eliminating unnecessary tables and columns.

 If you are managing your date tables explicitly (which is a good practice for better control and performance), it is generally recommended to uncheck the auto date/time option to avoid any unintended creation of hidden date tables for other date columns in your model.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

2 REPLIES 2
AndyHermle
Helper I
Helper I

Thank you very much Amira for the insights and the best practice method. 

AmiraBedh
Super User
Super User

When you mark a table as a date table, Power BI stops generating hidden date tables and hierarchies for that specific table. This helps reduce the model size and improves performance by eliminating unnecessary tables and columns.

 If you are managing your date tables explicitly (which is a good practice for better control and performance), it is generally recommended to uncheck the auto date/time option to avoid any unintended creation of hidden date tables for other date columns in your model.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors