1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Pivot and Data Models - updating data? Switching out what's behind pivot?

I'm trying to learn Power Pivot so I can use larger and different data sets using data models. For now, I only care about a single large data set (though I ultimately have others too) and a corresponding pivot table.

The data set is in the data model as "load to" connection only and add to data model.

I re-ran that data set updated and want to do what effectively I do with Excel datasets, just copy paste over the first and refresh the pivot table. I can't delete the original query and rename the new one and repoint because the pivot table automatically is cleared. I don't know if there's any other way to remove the original data set and overwrite with the new? I have one measure or calculated field in the data that I did recreate.

I want to avoid recreating the pivot every time because that's inefficient.

How do I approach this?

submitted by /u/JayReddt
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article