Connection could not be validated when using Excel data source

Using an Excel data source, and receiving an error that says “Connection could not be validated”.  When clicking on Details, the message says “ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”If you are on SmartConnect 2018 or lower you need to install  32 Bit Excel/Office ODBC Drivers on each machine … Continue reading Connection could not be validated when using Excel data source