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.