Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server Analysis Services
Azure Analysis Services
Fabric/Power BI Premium
This topic describes the types of data sources that you can use in a multidimensional model.
You can retrieve data from the data sources in the following table. When you install SQL Server Data Tools, setup does not install the providers that are listed for each data source. Some providers might already be installed with other applications on your computer; in other cases you will need to download and install the provider.
Note
Third party providers, such as the Oracle OLE DB Provider, may also be used to connect to third party databases, with support provided by those third parties.
Source | Versions | File type | Providers* |
---|---|---|---|
Access databases | Microsoft Access 2010, 2013, 2016 | .accdb or .mdb | Microsoft Jet 4.0 OLE DB provider |
SQL Server relational databases* | Microsoft SQL Server 2008, 2008 R2, 2012, 2014, 2016, Azure SQL Database, Azure Synapse Analytics (SQL Data Warehouse), Microsoft Analytics Platform System (APS) Note: For more information about SQL Database on Azure.com. Note: Analytics Platform System (APS) was formerly known as SQL Server Parallel Data Warehouse (PDW). Originally, connecting to PDW from Analysis Services required a special data provider. This provider was replaced in SQL Server 2012. Starting in SQL Server 2012, the SQL Server native client is used for connections to PDW/APS. |
(not applicable) | OLE DB Provider for SQL Server SQL Server Native Client OLE DB Provider SQL Server Native 11.0 Client OLE DB Provider .NET Framework Data Provider for SQL Client |
Oracle relational databases | Oracle 9i, 10g, 11g, 12g | (not applicable) | Oracle OLE DB Provider .NET Framework Data Provider for Oracle Client .NET Framework Data Provider for SQL Server OraOLEDB MSDASQL |
Teradata relational databases | Teradata V2R6, V12 | (not applicable) | TDOLEDB OLE DB provider .Net Data Provider for Teradata |
Informix relational databases | V11.10 | (not applicable) | Informix OLE DB provider |
IBM DB2 relational databases | 8.1 | (not applicable) | DB2OLEDB |
Sybase Adaptive Server Enterprise (ASE) relational databases | 15.0.2 | (not applicable) | Sybase OLE DB provider |
Other relational databases | (not applicable) | (not applicable) | An OLE DB provider |
* ODBC data sources are not supported for multidimensional solutions. Although Analysis Services itself will handle the connection, the designers in SQL Server Data Tools used for building solutions cannot connect to an ODBC data source, even when using the MSDASQL driver. If your business requirements include an ODBC data source, consider building a Tabular solution instead.
** Some features require a SQL Server relational database that runs on-premises. Specifically, writeback, and ROLAP storage require that the underlying data source is a SQL Server relational database.
Data Sources Supported
Data Sources in Multidimensional Models
Data Source Views in Multidimensional Models
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Manage Data Sources with External Data Stores in Finance and Operations apps - Training
Administrators often need access to their data from finance and operations apps, to perform analytics that will help ensure that certain parameters or business metrics are met.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.