How can we update the source query for an existing connection RRS feed

  • Question

  • We have hit a bit of a wall with updating the data that we are importing.  We are doing research on a data set and are wanting to add columns to a powerpivot data set.  The only way that we have discerned to add columns from the data source (not calculated columns based on current data) is to delete the data set and reimport.  This destroys any of the PowerPivot for excel work that we have completed though.  Any help or direction is appreciated.
    Wednesday, September 1, 2010 3:14 PM


  • I am going to reply to this for others benefit.  We discovered that this is found under Table Properties on the individual tab that the data is found on in the Power Pivot UI.
    • Marked as answer by Dweh01 Wednesday, September 1, 2010 4:05 PM
    Wednesday, September 1, 2010 4:05 PM