Process only a table in an Azure Analysis Service database, in Azure Data Factory

[Victornld2]

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. But I need to execute a pipeline to process a small writeback table, which is connected with a Power BI report. 

Step 1 is to be able to process only a table, step 2 is to make a customized button in the Power BI report to trigger the pipeline.

[NandanHegde · Accepted solution]

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 

[Victornld2]

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!

[NandanHegde]

Glad it worked!!

[Anonymous]

Hi @Victornld2 ,

Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.

[Anonymous]

Hi @Victornld2 ,

Apologies for the inconvenience, this community is specifically for discussions and questions related to Microsoft Fabric. For queries related to Azure Data Factory (ADF), we recommend using the dedicated Microsoft Q&A forum where they are ready to assist you better. Here's the link to post your query in Microsoft Q&A : Ask a question - Microsoft Q&A.

Thanks.