Edit Table Properties Dialog Box
The Edit Table Properties dialog box enables you to view and modify the properties of tables that are imported into the PowerPivot window by using the Table Import Wizard Reference. To access this dialog box, select a table of data that was imported, and then on the Design tab, in the Properties group, click Table Properties.
The options for this dialog box are different, depending on whether you originally imported data by selecting tables from a list or by using a SQL query.
Table Preview Mode
Table name
Displays the name of the data table in the PowerPivot workbook.Note
You cannot edit the name here. However, you can change the name of the table by right-clicking the table tab at the bottom of the PowerPivot window.
Connection name
Displays the name of the connection that is currently in use. For information about changing connection properties, see Edit the Properties of an Existing Data Source.Source name
Display or change the table from which the data is obtained.If you change the source to a table that has different columns than the current table, a message is displayed warning that the columns are different. You must then select the columns that you want to put in the current table and click Save. You can replace the entire table by selecting the check box at the left of the table.
Note
When you change the data source of a table, you essentially replace the contents of the current table with the contents of the new source table.
Column names from
Source
Select this option to replace the current column names with the column names from the selected source table.
PowerPivot Data
Select this option to use the current column names, and ignore the names in the selected source table.
Refresh preview
Click to view the columns of data in the currently selected source table.Switch to
Table preview
Select this option from the list to preview the selected table and a few rows of data.
Query editor
Select this option from the list to view the query against the selected data source. This option is not available for all data sources.
Checkbox in the column header
Select the checkbox to include the column in the data import. Clear the checkbox to remove the column from the data import.Down-arrow button in the column header
Filter data in the column.Clear row filters
Click to remove any filters that have been applied.Save
Click to apply all changes that you made, including replacing columns.
Query Design Mode
Table name
Displays the name of the data table in the PowerPivot workbook.Note
You cannot edit the name here; however, you can change the name of the table by right-clicking the table tab at the bottom of the PowerPivot window.
Connection name
Displays the name of the connection that is currently in use. For information about changing connection properties, see Edit the Properties of an Existing Data Source.Switch to
Table preview
Select this option from the list to preview the selected table and a few rows of data.
Query editor
Select this option from the list to view the query that will be issued against the selected data source.
Sql statement
Displays the SQL statement that is issued against the current data source to retrieve rows. By default, all rows are retrieved, but you can retrieve a subset of rows, either by designing a filter, or by manually editing the SQL statement.Validate
Click to verify that the statement is syntactically correct for the selected data source and provider.Design
Click to open a visual query designer and build a query statement. For information about how to use the designer, press F1 from the designer.Save
Click to apply all changes that you made, including replacing columns.