question

RRNetha avatar image
0 Votes"
RRNetha asked NandanHegde-7720 commented

Azure Analysis services process automation

Hi - Can I automate the processing of the Azure Analysis services cube using Data Integration pipeline in Synapse workspace without using Azure automation runbook or logic apps. Please point me to respective documentation URLS. Also enlighten me on is it good to do it in Azure automation runbook or Logic app or in Integration pipeline.

azure-data-factoryazure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered NandanHegde-7720 commented

Hey,
It is possible to process AAS via web activity through REST API.

Git hub repo for code:
https://github.com/NandanHegde15/Azure-DataFactory-Generic-Pipelines/tree/main/Azure%20Analysis%20Service/ProcessAzureAS

W.r.t the other question: it basically depends on your data ingestion process.
Ideally once the data ingestion is successful,then you process the cube.
So in case if you use an ADF to ingest the data
It would be better to leverage that for cube processing.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HI @NandanHegde-7720 - I have gone through the github for code. One quick question, which service principle I need to use here to execute the pipeline. Is it synapse managed identity or Service principle created separately.

0 Votes 0 ·

Hey
https://github.com/furmangg/automating-azure-analysis-services/tree/master/ADFv2

Hey you can refer the above post which has option of MSI or a new service principal from AAD

1 Vote 1 ·