Analyze in Excel Standard Pivot Table Aggregations

The Analyze in Excel feature is an excellent addition to Power BI. For an enhancement, I recommend adding the ability to utilize Excel's standard pivot table functionality of adding implicit measures for numeric fields from source data. This functionality would be similar to the process for creating pivot tables with Power Pivot where custom measures can be used with standard Excel measures in the same pivot table.

The requirement to create custom measures for simple aggregations (i.e. sum of xx numeric field) removes one of the largest advantages of creating summarizations in Excel. It is also difficult for report developers to anticipate all potential aggregations the end user will want to review. Consistent pivot table functionality in Excel is important for this feature since the target audience for results are Excel users.