Hey all - I'm trying to use Workbooks more but running into an issue. Seems like I can only return 200,000 lines of data at a time, which isn't much when I'm pulling in line-level data. Anyone know if 200,000 is a hard limit or if there's some way to adjust?

Honestly, I'd dump your NS search to a CSV ,import that into Excel, and use Power Query/Pivot to shape your data. NS Workbooks are not remotely as fast, functional, or powerful. 64-bit Excel has a 1,048,576 line limit. The practical limit will be a bit less depending on your hardware, but it'll still be far better than 200K.

Thanks @Cameron - that's definitely the approach we're taking for one-off analysis. Where we'd like to use Workbooks is for ongoing standard report so we don't have to recreate the report each time - hoping they continue to invest in improving this feature.