Microsoft has issued more updates this week to Excel 2013. If you’re a fan of the most powerful software Microsoft has created, this is fun!
Using Power Query with Power Pivot
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
- Using Power Query, import your data from a data source of your choice.
- Once your Power Query data manipulations are complete, select Close & Load To…
- When prompted, select Add this data to the Data Model and then click Load.
- Next, open the PowerPivot window, select a column on the table you just loaded using Power Query and rename that column. The same will apply to delete column, delete table and edit table as mentioned above.
- An attempt to rename a column in the model created with Power Query is blocked with a message that data originated in Power Query should be updated in Power Query; doing this prevents conflicts between the two tools.
Power Pivot allows customers to define KPIs with various settings such as the target value, icon styles and KPI description.
The Excel 2013 update for KPIs includes:
- Additional icon sets for a KPI status, including five levels of icon sets.
- Alignment with the absolute KPI target value data type with that of the type of the measure. As a result, both Value and Goal measures now show the same data type on a PivotTable.