Microsoft Query error when querying more than one table

Issue:
Using Microsoft Query to connect to a HP Vertica database, I cannot add more than one table for visualization in Microsoft Query but I am able to in Microsoft Excel using the Data ODBC connection. I am also able to view any table content in the Linux server or in DBVisualizer (database management tool)

The error in Microsoft Query says:
[20] An error occurred during query execution: Multiple commands cannot be active on the same connection. Consider increasing ResultBufferSize or fetching all results before initiating another command.