Hi everyone,
I have created an SSAS Tabular model using data from Azure Databricks through an ODBC DSN. The model was deployed successfully without any issues.
After deployment, I connected to the same model using SSMS. However, when I try to process (refresh) a partition of one of the tables, I receive the following error:
Failed to save modifications to the server. Error returned:
'On-Premise Gateway is required to access the data source. Please install a unified gateway for the server <server_name> or disable AlwaysUseGateway setting if it's enabled.
Technical Details:
RootActivityId: bf18614e-5328-43b3-8732-48560bb528ad
Date (UTC): 7/31/2026 9:10:59 AM'
What I've already checked:
-
Created the model using an ODBC DSN that connects to Azure Databricks.
-
Successfully deployed the model.
-
Verified that the AlwaysUseGateway setting is disabled (False).
-
Restarted/redeployed after changing the setting, but the issue still persists.
Has anyone encountered this issue before?
I'm trying to understand:
-
Why is the server still requesting an On-Premises Data Gateway even though AlwaysUseGateway is set to False?
-
Are there any additional server-level or model-level settings that could still force gateway usage?
-
Is there any requirement when using an ODBC DSN with Azure Databricks that would cause the refresh to require a gateway?
Any suggestions or guidance would be greatly appreciated.
Thank you!
