Tableau Desktop can not connect to views on local MySQL database. Tables work fine.

I am running Tableau Desktop (2020.3.0) using the driver: [MySQL][ODBC 5.3(w) Driver][mysqld-8.0.20].

I run a local MySQL server. When I connect I can connect to tables on the server without problems. I can however not connect to Views. I see the views in the list, but when I connect I get this error message:

​

"An error occurred while communicating with the MySQL data source 'ShowData'

Bad Connection: Tableau could not connect to the data source.

Error Code: 08F00D51

[MySQL][ODBC 5.3(w) Driver][mysqld-8.0.20]Source character set not supported by client

Unable to connect to the MySQL server "localhost". Check that the server is running and that you have access privileges to the requested database."

​

I checked in MySQL workbench what character set I am running. It is utf8 and collation is default collation.

​

The error code in the message gives no result.

​

I tried a different client (dBeaver) and that works fine too and I can see and query the views using the same user, so it's not a matter priviliges.

​

I tried connecting through hostname 'localhost' as well as 127.0.0.1 and I tried both MySQL as well as MariaDB drivers.

​

I created the simplest of views containing just one column of integers, but it does not connect. Anyone familiar with this problem?

​

cheers

Thomas​