Hello guys,
I have a dataset that has been successfully updated in the PowerPivot Data Model (comprising approximately 40 million rows).
There is a parameter that has over 1,048,000 variables (approximately 2,5 million unique values), on which I want to create a powerpivot.
Is there any trick to create a powerpivot in excel that can exceed the normal ROW limitation in excel (that approx 1 milion rows) ?
Thank you very much
Looking forward to hearing from you
George
Bookmarks