Hi everyone,
I'm building a new tabular model in Azure Analysis Services (1500 compatibility), and one of the data sources in my model is another Azure Analysis Services model managed by another team. Essentially I'm using Power Query's "AnalysisServices.Database" function to import small subsets of data from their model into mine via DAX queries. All of the data in both mine & the other team's model is sourced in the cloud via Blob Storage or Azure Synapse.
I can reprocess the data in my model on my local PC without issue, but when attempting to deploy to my own AAS server, I receive an error stating that an on-premises gateway is required for this connection. This shouldn't be possible as nothing is sourced on-premises: everything in my model & the other team's model is in the cloud. I've also confirmed that the "AlwaysUseGateway" setting is false in both servers.
Has anyone ever tried doing what I'm trying to do, and do you have any advice on what I can do to bypass this? I can always try installing an enterprise gateway on both servers, but I'd like to first understand why this is even required for AS models stored in the cloud.
Thank you!
