Data sources supported in SQL Server Analysis Services tabular 1400 and higher models
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
This article describes the types of data sources that can be used with SQL Server Analysis Services (SSAS) tabular models at the 1400 and higher compatibility level. For Azure Analysis Services, see Data sources supported in Azure Analysis Services.
Cloud data sources
| Datasource | In-memory | DirectQuery |
|---|---|---|
| Azure SQL Database | Yes | Yes |
| Azure Synapse Analytics (SQL Data Warehouse) | Yes | Yes |
| Azure Blob Storage | Yes | No |
| Azure Table Storage | Yes | No |
| Azure Cosmos DB | Yes | No |
| Azure Data Lake Store (Gen1)1 | Yes | No |
| Azure HDInsight HDFS | Yes | No |
| Azure HDInsight Spark 2 | Yes | No |
1 - ADLS Gen2 is currently not supported.
2 - Azure Databricks using the Spark connector is currently not supported.
Provider
In-memory and DirectQuery models connecting to Azure data sources use .NET Framework Data Provider for SQL Server.
On-premises data sources
Supported by in-memory and DirectQuery models
| Datasource | In-memory provider | DirectQuery provider |
|---|---|---|
| SQL Server | Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), .NET Framework Data Provider for SQL Server | .NET Framework Data Provider for SQL Server |
| SQL Server Data Warehouse | Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), .NET Framework Data Provider for SQL Server | .NET Framework Data Provider for SQL Server |
| Oracle | Oracle Data Provider for .NET | Oracle Data Provider for .NET |
| Teradata | OLE DB Provider for Teradata, Teradata Data Provider for .NET | Teradata Data Provider for .NET |
Note
For in-memory models, OLE DB providers can provide better performance for large-scale data. When choosing between different providers for the same data source, try the OLE DB provider first.
Supported by in-memory models only
Database
Access Database
SQL Server Analysis Services
IBM Informix (beta)
JSON document
Lines from binary
MySQL Database
PostgreSQL Database
SAP HANA
SAP Business Warehouse
Sybase Database
File
Excel workbook
Folder
JSON
Text/CSV
XML table
Online services
Dynamics 365
Exchange Online
Saleforce Objects
Salesforce Reports
SharePoint Online List
Other
Active Directory
Exhange
OData Feed
ODBC query
OLE DB
SharePoint list
See also
Data sources supported in SQL Server Analysis Services tabular 1200 models
Data sources supported in Azure Analysis Services