Forum Discussion

Chelly's avatar
Chelly
Frequent Visitor
2 years ago
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...
Dataflows
Need Help
Tutorial Requests
NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago

Hey,

unfortunately Fabric dataflow gen2 and data pipelines do not support SSAS as connector :

https://community.fabric.microsoft.com/t5/Service/SQL-Server-Analysis-Services-as-a-Dataflow/m-p/827053

 

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/