The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
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:
Solved! Go to Solution.
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!
Thanks, that works for me.
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!
User | Count |
---|---|
6 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
16 | |
15 | |
10 | |
6 | |
6 |