error with Auto/data time

[oren]

Hi

i am tring to get the mark back of  "Auto/data time" after i removed it and i get an error :

what can i do ?

thank you

[v-yalanwu-msft]

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.

[v-yalanwu-msft]

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.

[amitchandak]

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

[oren]

hi

cannot find it . see attached :

[oren]

i do found it , but i get the same massage:

[oren]

just to explain -  i get the same massage only if the mark the "Auto/data time" in the second "data load" .