There is no limit on the number of rows written to the drill-through table. If not specified, all rows will be written.
The maximum number of columns is not a specific number and depends on the DB. See this Wikipedia page for detailed information by DB type.