Share via


Specify a SQL or MDX Query

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

This page of the Table Import Wizard enables you to import data by using a SQL or MDX query. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.

The query can manipulate the data that is imported. For example, you could join data from different tables or select only rows that meet certain criteria.

Term

Definition

Friendly Query Name

Type a unique name for the query. This is a required field.

SQL Statement

Type or paste a SQL statement.

Validate

Determine if the SQL statement is valid.

Design

Design a SQL statement by using the query designer dialog box. For more information, see Relational Query Designer (PowerPivot).

See Also

Concepts

Data Sources Supported in PowerPivot Workbooks

Take a Tour of the PowerPivot UI

Other Resources

Add and Maintain Data in PowerPivot