Nuta
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować się zalogować lub zmienić katalog.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
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.
Related Tasks
| 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. |