Power Pivot Principles: Power PivotTables

Welcome back to our Power Pivot blog series. Today we discuss some pointers to consider when creating PivotTables from Power Pivot.

After importing data into Power Pivot, we may wish to create a PivotTable. There are a few things to note when creating a PivotTable form Power Pivot:

• The fields list contains fields from all of the tables from the Power Pivot model
• There is an included ‘Search’ bar, to help us find the specific field we are after:

• Note that the PivotTable is created on an ordinary Excel sheet. Power Pivot does not render any reports or visualisations: this is done elsewhere such as in a PivotChart, Excel or Power BI.

Other than that, we can just create a PivotTable like we normally would in Excel. We will come back to PivotTables later, but first we will cover several other topics before we can really build a PivotTable – until then feel free to experiment!

That’s it for this week, stay tuned to our blog page for more on Power Pivot. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.