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.