When your reporting job is too large and takes a long time to process (or even sometimes fails), you're encouraged to reduce your scope. For instance, run a PMR on your subsites instead of your whole site collection at once. However, if you want a global portrait of your site collection's permissions, it gets tricky.

It would be interesting to then have the ability to merge the individual reports together directly in Sharegate (not manually in Excel).