MS Powerpoint Pivot Limitation

Question

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

Answer 1

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

Answer 2

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

Answer 3

But are you talink about dragging the attributes in a PivotTable?

Answer 4

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