Excel Power Pivot & Power Query For Dummies
Book image
Explore Book Buy On Amazon
Pivot tables built on top of Power Pivot or the Internal Data Model come with limitations that could be showstoppers in terms of your reporting needs. Here's a quick rundown of the limitations you should consider before deciding to base your pivot table reporting on Power Pivot or the Internal Data Model:
  • The Group feature is disabled for Power Pivot–driven pivot tables. You can't roll dates into months, quarters, or years, for example.
  • In a standard pivot table, you can double-click a cell in the pivot to drill into to the rows that make up the figure in that cell. In Power Pivot–driven pivot tables, however, you see only the first 1,000 rows.
  • Power Pivot–driven pivot tables don't allow you to create the traditional Calculated Fields and Calculated Items found in standard Excel pivot tables.
  • Workbooks that use the Power Pivot data model can't be refreshed or configured if opened in a version of Excel earlier than Excel 2013.
  • You can't use custom lists to automatically sort the data in your Power Pivot–driven pivot tables.
  • Neither the Product nor Count Numbers summary calculations are available in Power Pivot–driven pivot tables.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category: