Import Data (SSAS Tabular)
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.
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:
Relational Data Sources include:
Microsoft SQL Server Analysis Services cube
Data feeds include:
Text files include:
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.
Describes how to import data from relational data sources such as a Microsoft SQL Server, Oracle, or Teradata database.
Describes how to import data from a multidimensional SQL Server Analysis Services cube.
Describes how to import data from a data feed such as a Microsoft Reporting Services report or Azure Data Market Dataset.
Describes how to import data from a Microsoft Excel Workbook or text file.
Describes how to add data to an existing table in the model designer by using Paste and Paste Append.