Share via

Import Data (SSAS Tabular)

  • Article

You can import data into a tabular model from a wide variety of sources. The topics in this section describe how to use the Data Import Wizard to connect to and select data to be imported into a model project.

Important

If any of the tables in your model will contain a large number of rows, consider importing only a subset of the data during model authoring. By importing a subset of the data, you can reduce processing time and consumption of workspace database server resources.

Using the Table Import Wizard, you can import data from the following data sources:

Data Source Description
Relational Databases Relational Data Sources include:

Microsoft SQL Server

Microsoft SQL Azure

Microsoft SQL Server Parallel Data Warehouse

Microsoft Access

Oracle

Teradata

Sybase

Informix

IBM DB2

OLEDB/ODBC
Multidimensional Sources Microsoft SQL Server Analysis Services cube
Data Feeds Data feeds include:

Microsoft Reporting Services Report

Azure DataMarket Dataset

Atom feeds from a public or corporate provider
Text Files Text files include:

Excel files (.xlsx)

Text file (.txt)

In addition to importing data by using the Table Import Wizard, you can paste copied data (from Clipboard) into a table. Pasted data behaves differently from data that has been imported from other data sources. Pasted data in tables do not have a Connection Name or Source Data property. Pasted data is persisted in the Model.bim file. When the project or Model.bim file is saved, the pasted data is also saved.

Topic Description
Import from a Relational Data Source (SSAS Tabular) Describes how to import data from relational data sources such as a Microsoft SQL Server, Oracle, or Teradata database.
Import from a Multidimensional Data Source (SSAS Tabular) Describes how to import data from a multidimensional SQL Server Analysis Services cube.
Import from a Data Feed (SSAS Tabular) Describes how to import data from a data feed such as a Microsoft Reporting Services report or Azure Data Market Dataset.
Import from a Text File (SSAS Tabular) Describes how to import data from a Microsoft Excel Workbook or text file.
Copy and Paste Data (SSAS Tabular) Describes how to add data to an existing table in the model designer by using Paste and Paste Append.