In Analysis Services, turning the AlwaysUseGateway property True/False

Question

Hi,
We have a requirement to set the AsPaaS\AlwaysUseGateway property to true and when not in use, turn the property to false
In simple words, we want to automate its value,setting it to true/false whenever we require
Is there any way to do this?

(the below screenshot is of the same property I changed through SSMS)

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

MSDN Source

Answer 1

Hello,

You can use TOM or XMLA, with the client libraries (AMO/ADOMD/PowerShell).

E.g. https://blog.crossjoin.co.uk/2019/08/25/setting-azure-analysis-services-server-properties-not-visible-in-sql-server-management-studio/ shows how to set a server property using an XMLA script.

MSDN Source