Forum Discussion
Solved
Connecting fabric with On-Premises SSAS Cubes
I've been struggling to find a straightforward solution for connecting Fabric or Azure data factory to an on-premises SSAS cube. I've searched extensively, but all I come across are guides on connec...
Hey,
unfortunately Fabric dataflow gen2 and data pipelines do not support SSAS as connector :
So as a work around, you would have to create a linked server between the SQL server instance and SSAS instance and leverage the SQL connector and then query via Openquery. The below blog explains the same :
https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/
