error with Auto/data time

oren , clear data management cache -> Under-> File -> options and setting -> Options -> data load and try to save again.

Hi, oren ;

Accroding to official document, When the option is enabled, Power BI Desktop creates a hidden auto date/time table for each date column, providing all of the following conditions are true:

• The table storage mode is Import
• The column data type is date or date/time
• The column isn't the "many" side of a model relationship

I test it, I don't know why you want to cancel apply Auto Date / time, but if you use this in your original model and use it as a relationship key, when you cancel Auto Date / time, this column will make an error and the relationship will also make an error.

https://www.youtube.com/watch?v=d4yAzhIQqNk

https://www.youtube.com/watch?v=xu3uDEHtCrg

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.

Hi, oren ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

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.