Connect large data table with ODBC (CData ODBC connecter)

I'm trying to create somes reports in PowerBI from Zoho using the CData Zoho ODBC driver. I belive a key table I require is the StageHistories table. However when I try to connect directly I get the error shown below.

I've tried running a direct SQL query and can return the first 100 rows but not sure how to bring more data through.

I've also tried running a query against StageHistories and a table I think we require LinkingModule2 but I'm having trouble querying against the LinkingModule2 table (although I can connect directly)

Re: Connect large data table with ODBC (CData ODBC connecter)

Yes this is the only way I'm able to access any of the data. So when I type in that SQL statement into that Power BI textbox I do get the first 100 rows, but for any practical needs obviously I need all the data. Do you know of any work arounds to import all of the data despite the large table size?