Azure-docs: Unable to find `AlwaysUseGateway` for AAS server

Created on 26 Feb 2020  Â·  5Comments  Â·  Source: MicrosoftDocs/azure-docs

Greetings,

I am currently on a project which uses AAS to read from an Azure Virtual Machine (Windows 10), to be transformed and later visualized using Power BI.

I could successfully install the on-premise data gateway on the virtual machine and create a gateway resource and connect it to my AAS server. However, I'm unsure how to read the data using AAS from the virtual machine via the gateway.

From my thorough research on web, I found this guide to use gateway for data sources on VNet. I tried to change my server configuration from SSMS but could not find the attribute AsPaaS \ AlwaysUseGateway. Please check the screenshot below:

aas-properties

Could you assist me on this please?

Many thanks,
Sam


Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Pri3 azure-analysis-servicesvc cxp product-question triaged

All 5 comments

@sameh-sharaf Click on the "Show Advanced (All) Properties", you will see the second option in the table.

@sameh-sharaf As mentioned in the document:

In SSMS > server > Properties > General, select Show Advanced (All) Properties.

In the ASPaaS\AlwaysUseGateway, select true.

image

Hope this helps.

@sameh-sharaf
We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

I want to have an option in the ARM deployment for that or some decent PowerShell based automation. All I can do at the moment is to execute an XMLA script against it

Does the value of AlwaysUseGateway go back to its default value (false) when AAS is restarted?

Was this page helpful?
0 / 5 - 0 ratings

Related issues

mrdfuse picture mrdfuse  Â·  3Comments

Favna picture Favna  Â·  3Comments

behnam89 picture behnam89  Â·  3Comments

jamesgallagher-ie picture jamesgallagher-ie  Â·  3Comments

AronT-TLV picture AronT-TLV  Â·  3Comments