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?
[link] [comments]
Want to read more?
Check out the full article on the original site