ssasazure-data-factory

Refresh SSAS post ETL Process job


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


Solution

  • 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. my below blog explains in detail w.r.t same: https://datasharkx.wordpress.com/2021/03/15/refresh-ssas-tabular-model-from-azure-data-factory/