Process Data + Process Recalc a AAS via Azure Data factory

Question

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>

Answer 1

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