Shortcomings of Power Pivot
There are a couple of limitations of Power Pivot-driven pivot tables that you need to recognize so that you can work out if you can use them or the internal data model.
Problem 1 – selecting multiple items
The first issue is with trying to group dates into quarters or years. You could Select Multiple Items and then select the relevant dates that you wanted, but this is very time-consuming. Also, it is likely that human error could occur, as you might miss-click on one of them:
Problem 2 – Power Pivot preview
The second problem is that in a standard pivot table, you can double-click on a cell and then see all the rows that make up that amount in that cell. In Power Pivot tables, you can only see the first 1,000 rows:
Problem 3 – calculated fields
The...