A tutorial showing how to import data from Excel, Access and many other sources
Part five 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
  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)

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 from other data sources

You can also load data into SSAS tabular from the following other sources (not covered in this tutorial):

Format Notes
Azure DataMarket Link to data held in Microsoft's cloud-based services, by subscribing to a data feed of interest.
SQL Server Parallel Data Warehouse When your database is seriously large you can accommodate it in a SQL Server PDW, and import data from there into your tabular model.
SharePoint There is no specific data source for importing from SharePoint; instead, just choose one of the standard formats shown above, but provide a complete path to your report, workbook or PowerPivot model. If your data is in a SharePoint list, you can export this as a data feed and import this data feed into your model.
Data feeds You can link to atom data feeds from the Internet and from other sources which support the Open Data Protocol (using files with extension .atomsvc).
Other databases Link to Oracle, Teradata, Sybase, Informix and DB2 in a similar way to linking to SQL Server.
OLEDB / ODBC Link to virtually any data source using these generic formats.

One of the great strengths of the tabular model is that you can combine tables based on almost any data source, and treat them equally within your model (without needing to know where they came from).

And with those words of wisdom, I've reached the end of this particular blog.

This blog has 0 threads Add post