Forum Discussion
Load one query into multiple pivot tables
So a couple things. You'd be loading the data table from Power Query, the table should automatically load as a proper Excel table, so that your Pivot Table source can just be Table_Name (if that were the table name that you loaded to the worksheet). When you refresh, the pivot table source is still the Table_Name, and so the range will automatically update.
As for the calculated fields, you most certainly can add calculated fields to the data model, and they will show up in your pivot table. You just need to create the calculated fields in the data model. Click on "Manage Data Model", and then add your calculated coulmn in the "Add Column" space. Or add a measure in the space below the table. Either way, it will load to your pivot table.
--Nate
So a couple things. You'd be loading the data table from Power Query, the table should automatically load as a proper Excel table, so that your Pivot Table source can just be Table_Name (if that were the table name that you loaded to the worksheet). When you refresh, the pivot table source is still the Table_Name, and so the range will automatically update.
As for the calculated fields, you most certainly can add calculated fields to the data model, and they will show up in your pivot table. You just need to create the calculated fields in the data model. Click on "Manage Data Model", and then add your calculated coulmn in the "Add Column" space. Or add a measure in the space below the table. Either way, it will load to your pivot table.
--Nate