none
MS Powerpoint Pivot Limitation

    Dotaz

  • This is a PowerPivot + SharePoint for Internet Sites Enterprise Edition case. Customer is evaluating PowerPivot as an alternate to Oracle for their reporting requirements. Feedback from Customer: We have come across a critical issue while doing the Power Pivot POC. During our analysis, we found that there is a limitation of only 60 columns / attributes which can be dragged to build the data model for the purpose of ad-hoc data browsing. Please let us know if this is some limitation with Power Pivot and in the event our understanding is correct, please let us know if there is some workaround in order to address this issue? Thanks
    Thanks, Faisal
    31. ledna 2012 10:36

Všechny reakce

  • What is the error you get? Are you referring to a limitation of columns in the same table? I think that more than 60 columns are supported, but I want to understand better to what limitation you are referring in order to investigate more on that.

    Marco


    Marco Russo http://www.powerpivotworkshop.com http://sqlblog.com/blogs/marco_russo
    31. ledna 2012 21:21
  • Hi Marco, The refernce here is to the limitation of only 60 columns / attributes which can be dragged to build the data model for the purpose of ad-hoc data browsing.


    Thanks, Faisal
    1. února 2012 8:22
  • But are you talink about dragging the attributes in a PivotTable?
    1. února 2012 8:25
  • Hi Faisal,

    Just like Marco Russo mentioned more than 60 columns are supported in PowerPivot, could you please give the steps to reproduce your scenario and give the detail information, thanks for your effort.

    Regards,

     


    Challen Fu

    TechNet Community Support

    3. února 2012 8:23
    Moderátor