Share via

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.
454 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,740 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 32,991 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.