|Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table?|
|Written by PowerPivot-Info.com|
|Wednesday, 24 March 2010 01:40|
Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table?
Note: These instructions will work just with the latest build of PowerPivot (not available to public). These steps will not work with PowerPivot for Excel November CTP (CTP3
A: In the PowerPivot window select table that you would like to update, then select "Design" pane and click on the "Table Properties" menu button
New window will open "Edit Table Properties" and PowerPivot will read sample set of your data from the connection source.
If in the source table PowerPivot will find additional column, then they will be added to the end of column list. You will not get any warning about this. If some of the columns from the source table were dropped, then they will not appear in the table preivew and you will get warning message:
The following columns are not present in source: Column1, Column2
Click on the "Save" button to save new source table structure in the PowerPivot and then to reload data.
- PowerPivot / PowerView Excel Workbook Optimizer
- DAX Studio - Free Excel Add-in
- How to solve issue when PowerPivot for Excel crashes on all workbooks
- Using PowerPivot to analyze web access log in "Combined Log" format (CLF)
- Q: I have integer amount that represents duration in seconds. How can show this amount in format "h:mm:ss"?
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?