For tabular models at the 1200 and lower compatiblity levels, you can import data from a variety of relational databases by using the Table Import Wizard. The wizard is available in SQL Server Data Tools (SSDT), on the Model menu. To connect to a data source, you must have the appropriate provider installed on your computer. For more information about supported data sources and providers, see Data Sources Supported (SSAS Tabular).
The Table Import Wizard supports importing data from the following data sources:
Microsoft SQL Server database
Microsoft SQL Azure
Microsoft Access database
Microsoft SQL Server Parallel Data Warehouse
Microsoft SQL Server Analysis Services cube
The Table Import Wizard does not support importing data from a Power Pivot Workbook as a data source.
To import data from a database
In SQL Server Data Tools (SSDT), click the Model menu, and then click Import from Data Source.
On the Connect to a Data Source page, select the type of database to connect to, and then click Next.
Follow the steps in the Table Import Wizard. On subsequent pages, you will be able to select specific tables and views or apply filters by using the Select Tables and Views page or by creating a SQL query on Specify a SQL Query page.