| A Peek Inside: Unloading PowerPivot data |
| Written by Dave Wickert |
| Saturday, 06 March 2010 02:17 |
|
Ok folks. Here comes a cool one. As I am sure that everyone is aware by now, one of the most powerful new features of PowerPivot is that we do on-demand loading of embedded data. Well, if you are going to load it, then you had better at least think about unload it at some time. There is probably some law of thermodynamics that applies here. First rule for deleting data is that we don’t touch data if there are users currently connected to it. But other than that, any databases loaded or cached by the PSS (i.e. their database folder is contained in the SSAS Backup folder tree) are candidates for being unloaded. There are two ways that databases can be unloaded in PowerPivot:
|
Author articles
- Video - Deploying and Managing Microsoft SQL Server PowerPivot for SharePoint
- General problems with Gallery snapshots not being taken - no items listed in the ULS log
- Importing XML data
- Data feeds: Cannot get schema? But it is there ...
- Snapshots not being taken
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
