topic Re: Process only a table in an Azure Analysis Service database, in Azure Data Factory in Pipelines

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

Victornld2 — Tue, 02 Apr 2024 19:32:38 GMT

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.

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

Anonymous — Wed, 03 Apr 2024 08:13:03 GMT

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.

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

NandanHegde — Thu, 04 Apr 2024 04:06:50 GMT

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

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

Victornld2 — Thu, 04 Apr 2024 06:51:32 GMT

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!

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

NandanHegde — Thu, 04 Apr 2024 07:00:06 GMT

Glad it worked!!

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

Anonymous — Thu, 04 Apr 2024 13:52:59 GMT

Hi Victornld2 ,

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