question

AashishPatidar-3157 avatar image
0 Votes"
AashishPatidar-3157 asked NandanHegde-7720 commented

Refresh SSAS from Azure data factory

Based on MSFT documentation, there is no direct connector to SSAS and so is there any way via which we can process SSAS from ADF ?
As we have our SSAS but our source is Azure SQL which gets populated via ADF

azure-data-factorysql-server-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.

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

Hey @AashishPatidar-3157 ,
Yes, there is no direct connector to SSAS in ADF but you can leverage the concept of linked server across SSAS and database and connect to database to process the cube.
the below link explains in detail w.r.t same:
https://datasharkx.wordpress.com/2021/03/15/refresh-ssas-tabular-model-from-azure-data-factory/

@MartinJaffer-MSFT @KranthiPakala-MSFT :
Please suggest whether this is the only approach or are there any other way as well?
And I have seen multiple feedbacks or queries w.r.t connectivity to SSAS or AAS via ADF, So is that in ADF product teams considerations in future?

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.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered NandanHegde-7720 commented

Seems there is no official release that this on SSAS would be support soon.

But, I've seen this as one request on Azure feedbacks for AAS, refreshing Azure Analysis Cube . Maybe the product team is working on it.


· 1
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.

Thanks @LukasYu-msft for the update.
Then @AashishPatidar-3157 , you need to follow the linked server approach

0 Votes 0 ·