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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#large dataset processing
#real-time collaboration
#Power Pivot
#Data Models