Forum Discussion

Victornld2's avatar
Victornld2
Frequent Visitor
2 years ago
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. 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.

pipelines
  • NandanHegde's avatar
    NandanHegde
    2 years ago

    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 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • NandanHegde's avatar
    NandanHegde
    Super User
    2 years ago

    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's avatar
      Victornld2
      Frequent Visitor
      2 years ago

      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!