# \#ssas

**URL:** https://community.cdata.com/tag/ssas/263.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [SSAS Model Refresh Fails with "On-Premise Gateway is required" Even After Disabling AlwaysUseGateway](https://community.cdata.com/t/ssas-model-refresh-fails-with-on-premise-gateway-is-required-even-after-disabling-alwaysusegateway/1321)

<div class="topic-metadata">

**Author:** [@naveensaidadi](https://community.cdata.com/u/naveensaidadi)\
**Replies:** 1\
**Last updated:** [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 "2026-08-14T14:45:43Z")

</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…

---

## [ODBC SSAS (SQL Server Analysis Services) Tabular: “\[DataSource.Error\] ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified.”](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889)

<div class="topic-metadata">

**Author:** [@Florjan\_C](https://community.cdata.com/u/Florjan_C)\
**Replies:** 0\
**Last updated:** [August 23, 2024, 7:36pm UTC](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889 "2024-08-23T19:36:16Z")

</div>

“ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified” error means that the Data Source Name (DSN) specified in the connection configuration is not being found i…

---

## [“Object reference” error when editing the connection string in a deployed SSAS project in SSMS](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647)

<div class="topic-metadata">

**Author:** [@John\_G](https://community.cdata.com/u/John_G)\
**Replies:** 0\
**Last updated:** [March 1, 2024, 2:23pm UTC](https://community.cdata.com/t/object-reference-error-when-editing-the-connection-string-in-a-deployed-ssas-project-in-ssms/647 "2024-03-01T14:23:34Z")

</div>

When attempting to change the connection settings on a deployed SQL Server Analysis Services (SSAS) package in SQL Server Management Studio (SSMS), you may see an “Object reference not set to an instance of an object” er…

---

## [SSAS: Tabular and Multidimensional Models](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412)

<div class="topic-metadata">

**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\
**Replies:** 0\
**Last updated:** [September 22, 2023, 3:07pm UTC](https://community.cdata.com/t/ssas-tabular-and-multidimensional-models/412 "2023-09-22T15:07:37Z")

</div>

SQL Server Analysis Services (SSAS) allows you to build both tabular and multidimensional models. Tabular models support the relational model (model, tables, columns) of most data sources. Multidimensional models are Onl…