I have four tables in an Excel 2013 workbook generated from four different ODC files.
Using Power Query, I added all four tables to the Data Model and created a common list in a query. I created several pivot tables, added them to the sheet, and a slicer based on the common list that filter all my pivot tables on multiple worksheets.
I went back to the original data in Power BI and added columns, updated my ODC connections (which are a DAX SELECTCOLUMNS statement).
The tables on the worksheets updated just fine.
The queries in Power Query updated just fine.
When I refresh the pivot tables the new columns are not available in the Pivot Table Fields. I've tried Refresh All on the Data ribbon tab (and the tables and queries update), and also right-clicking on the individual pivot tables and clicking Refresh.
Any suggestions on getting these new columns to show up in the Pivot Table Fields section?