Getting dataset error: WWorkbench DataSet Job is not allowed to dynamically change schemas. Help!

When trying to refresh a dataset that has not loaded in 24 days, I am getting an error stating:

"Workbench DataSet Job (insertcompanynamehere.domo.com:6 (sqlSalesBI_uvwReportTwoYear) is not allowed to dynamically change schemas."

Β 

How do I resolve this?

Comments

  • rado98
    rado98 🟠

    Probably a a column or something was added to the dataset or something else was changed.

    Run a preview and then check the schema to see what might have changed.

    You can also tick "Allow Dinamic schema changes in the job settings, although I would no recommend it.