Error when refreshing dataset - "Unable to get tables."
I've not seen this error before and I'm unsure how to resolve other than dropping and recreating the dataset.
I have a dataset that has been established for a few months. It uses a SQL query versus a specific table. Over the last several days, we have seen error notifications that the data cannot be refreshed when our primary workflow kicks off.
When I try to refresh the data manually, it gives an error "Unable to get tables." and both the Configure and Apply buttons are greyed out.
I've tried editing the definition and can do so successfully, but with no changes to the error. The only thing I haven't done yet is drop and recreate the dataset.
Are there other steps I can take to troubleshoot this further? If my only other option is to drop and recreate the datasets, what impact will it have on our workflows? Will I need to update them, or will they still work as long as I use the same names for the datasets?