I have a file that has close to 2 million records (1.5gb) and it won't upload via manual load. I'm assuming we can load it via EPM Automate.
With that said, is there a document that explains max # of rows you can have in a file?
You should have more success with EPM Automate as it uploads files in chunks, the issue with uploading through Data Management is probably more around file size than number of records.
Anyway give EPM Automate a go.