CODEWITHSUNDEEP
azuressasssas-tabularazure-analysis-services
Martijn B
Martijn B

Reputation: 4075

Why do I need an Azure On-Premises Data Gateway for my Azure Analysis Service?

So I have this Azure Analysis Service where the data source of the cube points to an external (on prem) SQL Server database. For some reason it won't connect to it even when I have the proper firewall changes in place.

When processing the cube it complains that I need to install the on-premises data gateway.

So my question is: Is the on-premises data gateway mandatory for connecting to other sources outside Azure?

Upvotes: 1

Views: 1418

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

Per docs, all non-Azure data sources require the on-premises data gateway:

https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource

As to why, it's unusual and not recommended that you would expose your on-premises SQL Server for direct connection from the internet.

Upvotes: 2

Related Questions