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
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
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?
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.
Thanks @LukasYu-msft for the update.
Then @AashishPatidar-3157 , you need to follow the linked server approach
7 people are following this question.