Please note javascript is required for full website functionality.


Power Pivot in Excel 2013 Updated

16 November 2015

The recently released November Power Pivot for Excel 2013 updates make changes to how Power Query interacts with Power Pivot as well as providing support for Key Performance Indicators (KPI).

For data in Power Pivot that has been added through Power Query, the following operations can now only be done through Power Query, which resolves conflicts previously seen in Power Pivot:

  • Edit Table Properties
  • Column-level changes: Rename, Data type change, Delete
  • Table-level changes: Rename, Delete

For more information, please refer to the Microsoft website.