Supported Data Sources
| Source and Version |
Multidimensional |
Tabular |
Excel Power Pivot |
| 2008 R2 |
2012 |
2014 |
2016 |
2012 |
2014 |
2016 |
2016 Direct Query |
| SQL Server 7.0 / 2000 |
yes |
no |
no |
no |
no |
no |
no |
no |
no |
| SQL Server 2005 |
yes |
yes |
yes |
(no)? |
yes |
yes |
(no)? |
(no)? |
yes |
| SQL Server 2008 – 2012 |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
| SQL Server 2014 |
? |
(yes)* |
yes |
yes |
(yes)* |
(yes)* |
yes |
yes |
(yes)* |
| SQL Server 2016 |
? |
(yes)* |
(yes)* |
yes |
(yes)* |
(yes)* |
yes |
yes |
(yes)* |
| SQL Azure Database |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
| SQL Server Parallel Data Warehouse (PDW) / Analytics Platform System (APS) |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
| Oracle relational 9i, 10g, 11g |
yes (9.0) |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
| Oracle relational 12g |
? |
? |
? |
yes |
? |
? |
yes |
yes |
? |
| Teradata relational V2R6, V12 |
yes (v2R6) |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
yes |
| IBM DB2 relational V8.1 |
yes (with EE only) |
yes |
yes |
yes |
yes |
yes |
yes |
no |
yes |
| Informix relational V11.10 |
no |
yes |
yes |
yes |
yes |
yes |
yes |
no |
yes |
| Sybase relational |
no |
yes |
yes |
yes |
yes |
yes |
yes |
no |
yes |
| Text Files (.CSV, .TAB, .TXT) |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
| Microsoft Excel 97-2007 (.xlsx, .xlsm, xlsb, xltx, xltm) |
no |
no |
no |
no |
yes |
yes |
(no)? |
no |
yes |
| Microsoft Excel 2010 (.xlsx, .xlsm, xlsb, xltx, xltm) |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
| Microsoft Excel 2013-2016 (.xlsx, .xlsm, xlsb, xltx, xltm) |
no |
no |
no |
no |
(no)? |
(no)? |
yes |
no |
? |
| Excel documents in SharePoint |
no |
no |
no |
no |
no |
no |
no |
no |
no |
| Microsoft Access 2003 |
yes (x86 only) |
yes |
? |
? |
yes |
yes |
no |
no |
yes |
| Microsoft Access 2007 |
yes (x86 only) |
yes |
yes |
? |
yes |
yes |
no |
no |
yes |
| Microsoft Access 2010 |
? |
yes |
yes |
yes |
yes |
yes |
yes |
no |
yes |
| Microsoft Access 2013 |
? |
? |
yes |
yes |
(no)? |
? |
yes |
no |
? |
| Microsoft Access 2016 |
? |
? |
? |
yes |
(no)? |
? |
yes |
no |
? |
| Access documents in SharePoint |
no |
no |
no |
no |
no |
no |
no |
no |
no |
| Power Pivot Workbook published to SharePoint |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
| SSAS Analysis Services Cube (2005) |
no |
no |
no |
no |
yes |
yes |
(no)? |
no |
yes |
| SSAS Analysis Services Cube (2008-2008R2) |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
| SSAS Analysis Services Cube (2012-2014) |
no |
no |
no |
no |
(yes)* |
(yes)* |
yes |
no |
(yes)* |
| SSAS Analysis Services Cube (2016) |
no |
no |
no |
no |
? |
? |
yes |
no |
(yes)* |
| Data Feeds Atom 1.0 format (exposed via WCF Data Service) (.atomsvc or .atom) |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
| Office Database Connection files |
no |
no |
no |
no |
yes |
yes |
yes |
no |
yes |
Embracing your Transact-SQL Code and Coding Tips.