As the error indicates: Driver does not support this function.

The first thing Polybase does is retrieve the data types from the external table, and if the driver doesn't allow this, then this error is returned. There is no workaround about this, it's the way Polybase works, so if it can't get the datatypes first, it can't continue.

Try using a third party ODBC and see if it works.