Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Showing results for 
Search instead for 
Did you mean: 

Data Connection ODBC MySQL - Several tables/views can't be loaded ?

Hello, a customer uses QlikSense Enterprise August 2021 and a ODBC MySQL Connector. He has a lot of tables and views but there are several views which are not working as expected. In detail, if he manually writes in the script editor the query "select * from ...." the reload works; however, if he selects the data connection, the schema and the desired view, the screen keeps loading and the view is not loaded. Which could be the problem and how could it be fixed? Thanks,

Labels (3)
1 Reply

It could be that it's waiting for the view to return a count of the results and/or results for the preview.  Can you change over from Preview to Metadata?

talk is cheap, supply exceeds demand