A tutorial showing how to import data from Excel, Access and many other sources
Part one of a five-part series of blogs

You can import data into tabular models from virtually any data source, as shown by this tutorial.

  1. Importing data from other data sources (this blog)
  2. Importing data from Excel, Access, CSV files or the clipboard
  3. Importing data from SSRS (Reporting Services)
  4. Importing from Analysis Services cubes/tabular models
  5. Importing from other data sources

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 04 January 2016

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Importing data from other data sources

One of the fantastic things about SSAS tabular is that it's impossible to know where tables come from:

Tables from 3 data sources

Who's to know that these tables have been imported from Excel, Access and the clipboard, rather than from SQL Server?

This blog will show how to bring data in from all manner of data sources!  For the tables above, you could then manually create joins to get a database diagram:

Database diagram

I've added a measure to count the number of recalls.

You could then create a pivot table with this field list:

Pivot table fields

We've hidden all but a few fields.


And use this to create a pivot table like this:

Final pivot table

The final pivot table, bringing information in from 5 different tables imported from 3 different data sources!

Let's start by looking at how to import data from common Microsoft Office formats such as Excel and Access. 

This blog has 0 threads Add post