Edit Table Properties Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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.

See Also

Concepts

Edit the Properties of an Existing Data Source

Take a Tour of the PowerPivot UI