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:
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!
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!
