# SSAS Model Refresh Fails with "On-Premise Gateway is required" Even After Disabling AlwaysUseGateway

**URL:** <https://community.cdata.com/t/ssas-model-refresh-fails-with-on-premise-gateway-is-required-even-after-disabling-alwaysusegateway/1321>\
**Category:** Foundations\
**Tags:** question, cube, partitions, cube-partitions, ssas, gateway\
**Created:** [July 31, 2026, 10:32am UTC](https://community.cdata.com/t/ssas-model-refresh-fails-with-on-premise-gateway-is-required-even-after-disabling-alwaysusegateway/1321 "2026-07-31T10:32:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![naveensaidadi](https://avatars.discourse-cdn.com/v4/letter/n/bc8723/32.png) [@naveensaidadi](https://community.cdata.com/u/naveensaidadi)\
**Post date:** [July 31, 2026, 10:32am UTC](https://community.cdata.com/t/ssas-model-refresh-fails-with-on-premise-gateway-is-required-even-after-disabling-alwaysusegateway/1321/1 "2026-07-31T10:32:42Z")

</div>

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:

```auto
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-48560bb528adDate (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:

1. Why is the server still requesting an On-Premises Data Gateway even though **AlwaysUseGateway** is set to **False**?
2. Are there any additional server-level or model-level settings that could still force gateway usage?
3. 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!

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [August 14, 2026, 2:45pm UTC](https://community.cdata.com/t/ssas-model-refresh-fails-with-on-premise-gateway-is-required-even-after-disabling-alwaysusegateway/1321/2 "2026-08-14T14:45:43Z")

</div>

Hi ​ @naveensaidadi

The error message you are getting _“'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.”_ is not a CData error message but rather an error message from Micrsoft most commonly thrown by PowerBI Service. Could it be that you are trying to connect to PowerBI Report Server through the CData ODBC driver for Azure Databricks?

Based on your description, there are two possible causes I can think of:

1. You are not using the CData ODBC driver and getting an error unrelated to CData.
2. You have not installed the ODBC driver on the Server machine.

Either way, it would be helpful if you could share more details on the use case and how exactly are you deploying. In the meantime, I would recommend you take a look at our KB article below on how to set up SSAS Tabular via the CData ODBC driver for Databircks:

> **[Create SSAS Tabular Models from Databricks Data](https://www.cdata.com/kb/tech/databricks-odbc-ssas-tabular.rst)**
>
> How to build a SQL Server Analysis Service Tabular Model from Databricks data using CData drivers.

Also if the issue is only with accessing data in SSMS then you might want to consider setting up a Linked Server via the SQL Gateway that comes bundled with the CData ODBC driver:

> **[Connect to Databricks Data as a Linked Server via SQL Gateway](https://www.cdata.com/kb/tech/databricks-odbc-linked-server.rst)**
>
> Use the SQL Gateway and the ODBC Driver to set up a linked server for Databricks data.

If you have any other questions or issues feel free to contact the CData support team at [support@cdata.com](mailto:support@cdata.com)