Typically the error "The number of rows Tableau can load into memory for Document 1 has been exceeded. Reduce the selected schema levels and then try again." when connect to a JSON file that has multiple separate arrays results in Tableau duplicating rows.
When connecting to a JSON document with multiple arrays, Tableau creates a row for every combination of values in the arrays. As a result, an "out of memory" error may occur. This behavior is by design.
Since the file will need to be loaded into the memory of the machine running Tableau Desktop, I suggest limiting the nested array to a 10x10. Which results in about 10-billion rows.
Please see the article below for additional information:
I hope this information helps.