In this post I demonstrate how to update data in Powerpivots. Updates are different from a data refresh as updates incorporate new columns of data- so the structure of the underlying excel table changes. A standard data refresh wouldn’t pull in these new columns.