When I create a new pivot table, and use the big + button to add my own custom pivot report, it always has too much data, takes forever to run, and truncates the data. Why? Because I wasn't able to add any filters to show only my product. By default there are no filters, so the results for our entire portfolio stream into the table. I'm not sure how you'd solve this problem...maybe show the "Update" button first, and the user can add filters before they have the table results display? Or maybe there needs to be a filters dialog after you choose your primary field and add columns/rows, which would need to let you choose not only the filter set, but also which values you want to filter down to.
Or maybe by default pivot tables could have a filter for product, which defaults to the product or product line you're currently viewing. Then you could remove the filter if you dare, but at least the data is limited by default.