What is the impact of setting ASPaaS\AlwaysUseGateway to false

CuervoXok 1 Reputation point
2020-08-28T02:09:22.31+00:00

HI all everybody, this is my first post and I'm here to ask for your help.

This is the scenario on my Team:

  • Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue

And they sent me this image about the error they get:

21064-image.png

And the question that arrived to me about this is the following. I've spent many hours trying to understand the probable context of making this change but still not sure:

The request is: if the settings within the SQL Server (SQL Server in a VM) can be disabled and what’s the impact ?
Will it disable the VPN Gateway connectivity due to this setting change?

I really hope you can help me to understand what is the impact of setting this parameter to false.
Thanks a lot!

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-08-31T07:20:27.103+00:00

    Hi,
    For current scenario, we must install data gateway for your AAS to connect to a on-prem SQL Server(IaaS VM).
    A gateway is necessary for connecting to on-premises data sources only. But if your data sources are the cloud services on Azure, like Azure SQL Database,you don't need a gateway.
    See reference :How it works

    Regards,
    Lukas

    0 comments
  2. HarithaMaddi-MSFT 10,126 Reputation points
    2020-08-31T09:24:41.433+00:00

    Hi @CuervoXok ,

    Welcome to Microsoft Q&A Platform. Thanks for posting your query.

    Azure Analysis Services requires access to data sources in-order to perform data refresh operations. If the data sources are cloud-based and secured with a VNet, it is necessary to provide access to Analysis Services. This can be done using the AlwaysUseGateway server property. Setting this property to true specifies Azure Analysis Services always use an On-premises data gateway for access to data sources - whether or not the data source happens to be cloud-based. It therefore requires the On-premises data gateway is set up as described in this article, and the gateway computer resides on the VNet. Data refresh operations are directed to the gateway machine, which in-turn can successfully access the data source(s).

    When using this secure connection between Azure resources, we need to ensure "Allow access to Azure services" is OFF for those resources as setting this ON opens for all Azure resources communication. Please find a good article that explains this setup.

    When data sources are on-premise, this setting is mandatory and if it is cloud based data source, it is optional. For automating turning it ON and OFF, please check the article recommended by Analysis Services Team.

    Hope this helps! Please let us know for further queries and we will be glad to assist.

    0 comments