How do I change datasource for Pivot TAble(Power Pivot/Query)
Posted on 2014-07-24
I have an existing workbook that includes 2 worksheets linked to a SQL database, Using Power Query I appended these 2 worksheets to create the datasource for the Pivot Table (Pivot Data). I need to modify this data source to include another column, which I orginially hidden. I was able to change the Query to include this column and upon review of the Pivot Data, the column is visible. However, I am unable to get the Pivot Table to include this new column as part of the Table..
Also I attempted to change the Connection, without success.
How do I modify the connection or Pivot Table to include the necessary Columns without having to recreate the Pivot table from scratch?