How to manually refresh azure analysis services tabular model?

Question

Hello,

Could you please help to know how to manually refresh a table for updated data/newly created column/deleted column in tabular model of Azure Analysis Services?

Thanks in advance

Regards
Manish

Answer 1

Hi @Majumder, Manish ,

Thanks for using Microsoft Q&A !!

If you want to manually processing any specific table then from SSMS you can right click on the specific table and process the table like below -

You could do the same using PowerShell cmdlet Invoke-ProcessTable to Process any specific table of Azure Analysis Services model. You could something like below -

Invoke-ProcessTable -Server "asazure://westus2.asazure.windows.net/servername:rw" -DatabaseName "adventureworks" -TableName "Customer" -RefreshType DataOnly
Please refer to the documentation for details.

You can also use a REST api for Azure Analysis Services to refresh specific tables. You need to use POST against the "refreshes" endpoint and pass type of refresh (Full,DataOnly etc.) along with objects as Body of the call. Please see the below as an example -

Sample Request - https://westus.asazure.windows.net/servers/myserver/models/AdventureWorks/refreshes
Body

{  
    "Type": "Full",  
    "CommitMode": "transactional",  
    "MaxParallelism": 2,  
    "RetryCount": 2,  
    "Objects": [  
        {  
            "table": "Customer"  
        }  
    ]  
}  

Please note that when you do not pass any objects then the whole model is refreshed.
Please refer to the documentation - Asynchronous refresh with the REST API for details.

Please let me know if you have any other questions.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.