topic Where can I find Process Database dialogue box in SSMS or Tabular Editor in Data Engineering

Where can I find Process Database dialogue box in SSMS or Tabular Editor

Jeanxyz — Wed, 25 Jun 2025 15:34:02 GMT

I'm reading MS documentation, it says one can refresh database or tabular tables using the process database option, but I can't find this button in my SSMS.

MS doc:

To process a database

In SQL Server Management Studio, right-click on the database you want to process, and then click Process Database.
In the Process Database dialog box, in the Mode listbox, select one of the following process modes:
https://learn.microsoft.com/en-ca/analysis-services/tabular-models/process-database-table-or-partition-analysis-services?view=asallproducts-allversions

Re: Where can I find Process Database dialogue box in SSMS or Tabular Editor

v-sdhruv — Thu, 26 Jun 2025 07:54:05 GMT

Hi Jeanxyz ,

This dialog is typically used for tabular models deployed to Analysis Services and is not available for relational databases. You need to have a tabular model in SSAS deployed and then only you can use SSMS to connect to that model via Analysis services.

1. First connect to your Tabular model deployed in SSAS

2. Right click on the table

How to import data from sql server to SSAS

Hope this helps!

If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You!

Re: Where can I find Process Database dialogue box in SSMS or Tabular Editor

Jeanxyz — Thu, 26 Jun 2025 14:22:01 GMT

Thanks, that works for me.