Edit

Data sources supported in SQL Server Analysis Services tabular 1400 and higher models

  • Article

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