• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Where do the millions of rows live?

polarisking

polarisking

Member
I'm having trouble getting my head around the "Load" process. I get that while one's in the PQE the data file size is, for intents and purposes, unlimited.

But once your transform, Data Model, and everything else is complete and your opt for Load, it seems you're back in Excel which has the 2^20 row limit.

Do you have to stay in PQE to see and have access to row counts in excess of 1,048,576?
 
Load your data to the Data Model and then you can do analysis is Power Pivot. Alternatively, complete your analysis in PQE so that you end up with workable output that fits into Excel.
 
Thanks for replying, Alan.

So, for really large files, you can only deal with them in the PQE, Data Model, or Power BI. Would that be correct? I wonder if there’s a JET database behind all this (the engine supporting ACCESS)
 
You must log in or register to reply here.
Back
Top