+ Reply to Thread
Results 1 to 3 of 3

PowerPivot number of rows LIMITATION (in pivot table)

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    13

    PowerPivot number of rows LIMITATION (in pivot table)

    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

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: PowerPivot number of rows LIMITATION (in pivot table)

    If the result is greater than the max rows allowed, I think you are stuck and*need some more tricks.

    I'm thinking you might filter the data before it gets to the pivot. Perhaps using Power Query in the first step to filter out unwanted data and this might trim down the data so it would fit.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: PowerPivot number of rows LIMITATION (in pivot table)

    Unfortunately can't avoid it
    Think of a telecom provider with 4 million clients on which you have to conduct individual analysis - individual market intelligence parameters... seems Excels stops around ... here..
    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot Table is rubbish because of 256 limitation?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 31
    Last Post: 11-29-2019, 01:43 AM
  2. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  3. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  4. Pivot table missing rows using PowerPivot
    By djgfx in forum Excel General
    Replies: 1
    Last Post: 04-06-2011, 01:16 PM
  5. Pivot Table - Data Limitation
    By Garya in forum Excel General
    Replies: 3
    Last Post: 12-09-2008, 04:30 AM
  6. Pivot table - Charachter limitation
    By Darin Kramer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2005, 06:05 PM
  7. pivot table limitation
    By tchangmian in forum Excel General
    Replies: 1
    Last Post: 03-17-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1