Process Data + Process Recalc a AAS via Azure Data factory

Anonymous
2023-10-12T02:52:50.66+00:00

Hello everyone, I am currently refreshing the AAS model in full mode using the REST API called from ADF, but the processing time of some tables is quite large. I have read some methods to reduce processing time, including the ‘ProcessData Plus ProcessRecalc’ method, but it seems that it cannot be done or I do not fully understand it in the REST API documentation. Therefore, I would like to ask how to implement it or if there is any alternative solution?

Example of ProcessData Plus ProcessRecalc

XMLA command:

	<Batchxmlns='http://schemas.microsoft.com/analysisservices/2003/engine'Transaction='true'><Parallel>
		<Process>
			<Type>ProcessData</Type>
			<Object>
				<DatabaseID>AdventureWorks Tabular Model SQL 2012</DatabaseID>
				<DimensionID>Customer_08b41bba-8733-438e-a584-9894998b2f69</DimensionID>
			</Object>
		</Process>
		<Process>
			<Type>ProcessData</Type>
			<Object>
				<DatabaseID>AdventureWorks Tabular Model SQL 2012</DatabaseID>
				<DimensionID>Internet Sales_fdac9a13-4019-4773-b193-7cca3a4883eb</DimensionID>
			</Object>
		</Process>
		<Process>
			<Type>ProcessRecalc</Type>
			<Object>
				<DatabaseID>AdventureWorks Tabular Model SQL 2012</DatabaseID>
			</Object>
		</Process>
	</Parallel>
</Batch>
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,028 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 31,896 Reputation points Microsoft Employee
    2023-10-12T09:24:17.51+00:00

    Hi ivan il ,

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    It seems that you are looking for a way to reduce the processing time of tables in the Azure Analysis Services (AAS) model while performing refresh of the models using REST API in Azure data factory.

    Data-refresh operations can take some time depending on a number of factors including data volume, level of optimization using partitions, etc.

    The REST API for Azure Analysis Services enables data-refresh operations to be carried out asynchronously. By using the REST API, long-running HTTP connections from client applications aren't necessary. There are also other built-in features for reliability, such as auto retries and batched commits.

    You can use the POST method on the Refreshes collection to perform a refresh operation:

    https://westus.asazure.windows.net/servers/myserver/models/AdventureWorks/refreshes

    For authentication, kindly use the following resource: https://*.asazure.windows.net

    For details on implementation, kindly check out the resources:

    How to Process Azure Analysis Services Model from Azure Data Factory

    Process Analysis Service with Data Factory only