Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

How to import data for SSAS Tabular vNext


By:   |   Read Comments (1)   |   Related Tips: > Analysis Services Development

Attend these FREE SQL Server 2017 webcasts >> click to register


Problem

The experience of importing data into SSAS Tabular has been quite similar to importing data into Excel. Apart from providing the details of the data source and credentials, the ability to model the data (especially graphically) has been very limited. SSAS Tabular vNext introduces a new data import experience which makes the data import feature similar to Power BI Desktop and Excel 2016. In this tip we will look at the Data Import process in SSAS Tabular vNext.

Solution

SQL Server Data Tools (SSDT) 17.0 RC1 and SSAS vNext provide the GetData wizard to enable a modern data import experience for SSAS Tabular solutions.  In this tip we will cover the steps to import data.

1) Assuming that you already have SSDT installed as well as SSAS Tabular vNext, open SSDT and create a brand new and blank SSAS Tabular solution. Click on the menu item Model > Add Data Source. This should open a new Get Data wizard. Let's say we intend to import data from SQL Server, so select that option and click Connect.

Get Data

2) The next step is to provide server details. Provide the server name from where data is and click Next.

Get Data

3) The next step is to provide credentials to connect to the server. Provide the server name where the data is and click Next.

Get Data

4) You may get a notification as shown below depending on the encryption support of the data source.

Get Data

5) In this step, select the database from the server and click Next.

Get Data

6) Finally the data source has been added which you can see in the Tabular Model Explorer window.

Get Data

7) Right-click on the data source and select Import New Tables menu option.

Get Data

8) This step will display all the tables and views in the database. Depending on the selected object, you can preview the objects and also select the option to include related tables. Select the tables of your choice and click OK.

Get Data

9) This step provides the option of a full fledged query editor, which lets you manipulate the data as required. For now, click the Import button on the top-left corner.

Get Data

10) Once the import completes, you should be able to see a success confirmation.

Get Data

11) Finally you should be able to see the imported data as well as the table listed in the Tabular Model Explorer window.

Get Data

In this way, using the Get Data wizard, one can import data in a sophisticated manner with better control over the shape of the data.

Next Steps
  • Consider exploring the query editor to learn more about the query manipulation options.


Last Update:


signup button

next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Monday, February 13, 2017 - 8:37:48 AM - Koen Verbeeck Back To Top

You kind of underselled the importance of the new import process here. :)

It's basically Power Query inside Tabular (step 9), which makes it a really powerful tool to get data in Tabular.

Unless there's a follow-up tip planned? ;)


Learn more about SQL Server tools