Indeed, I just tried with 2007 and 2010 and got the same limit for "Show Details"

Just out of (silly) curiosity, I tried 5,000,000 in the Drillthrough and Visual Studio accepted it.

Within Excel, I had a warning that not all the data would fit in the spreadsheet and got 1048576 rows (including the 3 headers).

Pretty good!