Data not displaying in a generated table based on a mysql view

This option is available in the server connect database connection, not in the direct connection (database manager).

Also, if you don't see any data returned then again, as usual, when having such server-side problems just follow:

and see the exact error returned.