What is the maximum number of rows and columns provided in one input to the profiler with drill through on?

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.