Add Existing Pivot Table To Data Model. A problem I ran into when creating a new query in my freshly installed Microsoft Excel 2016 was that I could not import data to the Data Model. Heres a shot of some of our additional data.
Remove references to columns that are no longer used. We can connect almost any data source in Power Query but PowerPivot data model is not included in that extensive list of sources out of the box. How do I work with a pivot table from PowerPivot data.
In Excel click the Hosts tab to make it the active sheet.
You may use the refresh button under the Home tab to keep your data model updated. Add Excel Tables to a Data Model in Excel 2016. Not sure if this is what is causing my issues but in Excel 2016 when I try to expand the data set for a pivot table the table gets reset and I have to rebuild the table. In Excel 2013 I have one table Table1 in worksheet Data and I have a dozen pivot tables in another worksheet named PivotTable.
