#AZURE DATA STUDIO DATABRICKS INSTALL#

9 - For tabular 1200 models, or as a provider data source in tabular 1400+ models, specify Oracle Data Provider for.

#AZURE DATA STUDIO DATABRICKS INSTALL#

8 - If specifying MSOLEDBSQL as the data provider, it may be necessary to download and install the Microsoft OLE DB Driver for SQL Server on the same computer as the On-premises data gateway. NET Framework Data Provider for SQL Server.

7 - When specified as a provider data source in tabular 1200 and higher models, specify Microsoft OLE DB Driver for SQL Server MSOLEDBSQL (recommended), SQL Server Native Client 11.0, or. Notes: 6 - Tabular 1400 and higher models only. When using a gateway, 64-bit providers are required. Other data sourcesĬonnecting to on-premises data sources from an Azure Analysis Services server require an On-premises gateway. 5 - ADLS Gen2 connector is currently not supported, however, Azure Blob Storage connector can be used with an ADLS Gen2 data source. 4 - Azure Databricks using the Spark connector is currently not supported. If not enabled, an On-premises data gateway is required. Because SQL Managed Instance runs within Azure VNet with a private IP address, public endpoint must be enabled on the instance. 3 - Azure SQL Managed Instance is supported.

2 - When specified as a provider data source in tabular 1200 and higher models, both in-memory and DirectQuery models require Microsoft OLE DB Driver for SQL Server MSOLEDBSQL (recommended) or. Azure data sources Data sourceġ - Tabular 1400 and higher models only. The following tables describe supported data sources for Azure Analysis Services. The types of data sources you can connect to depend on many factors such as model compatibility level, available data connectors, authentication type, and On-premises data gateway support. However, not all data sources and connectors shown are supported in Azure Analysis Services. Data sources and connectors shown in Get Data or Table Import Wizard in Visual Studio with Analysis Services projects are shown for both Azure Analysis Services and SQL Server Analysis Services.

Azure data studio databricks