Forum Discussion
ODBC connection - Large table
Hi, I am trying to import a large table from a database that I connect to using an ODBC connection. I am finding that when I try to query the table and also refresh, it is taking a considerable ...
Is there a way to set a row limit for the data preview window in the get data wizard/workflow for ODBC sources? Every time a table is selected the data preview puts a query to the the underlying data source essentially doing a select *. If using direct query the SQL it passes to underlying source limits to 1000 rows. Why doesn't ODBC do the same thing? Unfortunately not all data sources can be connected via direct query so this limitation is tough to overcome on large tables