Forum Discussion
Solved
Process only a table in an Azure Analysis Service database, in Azure Data Factory
Hi everyone, I'm trying to process only a table in Azure Analysis Services database, via Azure Data factory. I can process the whole tabular model in a pipeline with parametrized url etc. Bu...
Hey,
You can leverage Web activity to process a single table in AAS via ADF :
URL :
@concat('https://',pipeline().parameters.Region,'.asazure.windows.net/servers/',pipeline().parameters.Server,'/models/',pipeline().parameters.DatabaseName,'/refreshes')Body :{"Type":"Full","CommitMode":"transactional","MaxParallelism":10,"RetryCount":2,"Objects":@{pipeline().parameters.Objects}}where objects are table names within AASTo answer to your other query, you can use Power automate visual and via power automtae trigger the ADF pipeline
Hey,
You can leverage Web activity to process a single table in AAS via ADF :
URL :
@concat('https://',pipeline().parameters.Region,'.asazure.windows.net/servers/',pipeline().parameters.Server,'/models/',pipeline().parameters.DatabaseName,'/refreshes')
Body :
{"Type":"Full","CommitMode":"transactional","MaxParallelism":10,"RetryCount":2,"Objects":@{pipeline().parameters.Objects}}
where objects are table names within AAS
To answer to your other query, you can use Power automate visual and via power automtae trigger the ADF pipeline
Got it to work, found out I had to specify the table (object) in the body.
Haven't been able to get the Power Automate to work. Might skip that part.
Thanks!
Glad it worked!!
Hi Victornld2 ,
Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.