The problem arises when your date columns are not in datetime64[ns] format and your non-datetime columns are in datetime64[ns] format. So make sure you correct your columns data types before passing it into the ydata_profiling module:

for i in ['effective_date']:
    df[i] = pd.to_datetime(df[i])