Adding Data to PowerPivot

You can import data into your PowerPivot workbook from a wide variety of sources. After you have imported the data, you can refresh the data at any time to reflect any changes to the data that have occurred in the source.

The topics in this section describe how to use the data import and data connection features in PowerPivot for Excel.

In This Section

• Data Sources Supported in PowerPivot Workbooks

• Data Types Supported in PowerPivot Workbooks

• Import Data from a Database

• Import Data from a File

• Import Data from Analysis Services or PowerPivot

• Import Data from a Reporting Services Report

• Import Data from a Data Feed

• Copy and Paste Data

• Add Data by using Excel Linked Tables

• Refreshing or Changing Imported Data

See Also

Other Resources

Introducing PowerPivot for Excel

Preparing Data for Analysis

Creating Reports, Charts, and PivotTables

Sharing PowerPivot Workbooks

Data Analysis Expressions (DAX) Language

UI Reference (PowerPivot for Excel)