Forum Discussion
Cannot load 11million record text file into Power Pivot
Hi, My platform is Windows 10 Enterprises - Version 1903. My Cdrive has 26.4 GB free. I have a Ddrive where the following data resides. I am able to successfully load a 10,389,648 record 4....
Hi Sergei -
Thanks for responding.
See below:
Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 16.0.14729.20156) 64-bit
Thanks for responding.
See below:
Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 16.0.14729.20156) 64-bit
I see, thank you.
To my knowledge size of Power Pivot table for 64 bit is limited only by memory. What else could be
- you use legacy From Text File connector within Power Pivot to import text file. In background it uses ACE OLEDB connector (Access one) which could have 2GB limit. You may try Power Query (aka structured data source connector) to load file into data model only.
- Excel file is hosted on SharePoint, it could have its own limit
- your Excel file is in binary format (xlsb) which also could have limits
Above only my guesses, I had no practical experience with text/csv of such size.