SQL Server Analysis Service [DEPRECATED]

Connect to SQL Server Analysis Service to create connection

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD)

Connector Metadata
Publisher	Microsoft

Creating a connection

The connector supports the following authentication types:


Azure AD Integrated	Use Azure Active Directory to access your SQL Server Analysis Service database.	All regions	Not shareable
SQL Server Authentication	Use an account name and password to access your SQL Server Analysis Service database.	All regions	Shareable
Windows Authentication	Use an on-premise Active Directory account name and password to access your SQL Server Analysis Service database.	All regions	Shareable
Default [DEPRECATED]	This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.	All regions	Not shareable

Auth ID: oauth

Applicable: All regions

Use Azure Active Directory to access your SQL Server Analysis Service database.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Auth ID: sqlAuthentication

Applicable: All regions

Use an account name and password to access your SQL Server Analysis Service database.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name	Type	Description	Required
SQL Server Analysis Service name	string	Specify the name of the SQL Server Analysis Service (server[:port])	True
SQL Server Analysis Service database name	string	SQL Server Analysis Service database name
Username	securestring	Username credential	True
Password	securestring	Password credential	True
Gateway	gatewaySetting	On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details

Auth ID: windowsAuthentication

Applicable: All regions

Use an on-premise Active Directory account name and password to access your SQL Server Analysis Service database.

Name	Type	Description	Required
SQL Server Analysis Service name	string	Specify the name of the SQL Server Analysis Service (server[:port])	True
SQL Server Analysis Service database name	string	SQL Server Analysis Service database name
Username	securestring	Username credential	True
Password	securestring	Password credential	True
Gateway	gatewaySetting	On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details	True

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
SQL Server Analysis Service name	string	SQL Server Analysis Service name	True
SQL Server Analysis Service database name	string	SQL Server Analysis Service database name
Authentication Type	string	Authentication type to connect to your database
Username	securestring	Username credential	True
Password	securestring	Password credential	True
Gateway	gatewaySetting	On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details

Name	Calls	Renewal Period
API calls per connection	5000	60 seconds