Forum Discussion
Unable to connect to On Prem Analysis server (SQL Server)
My requirement is as below Source: On Prem Analysis server (SQL Server) I would like to connect to Fabric from On prem Analysis server. But I don't see any options to pull data from On prem Analysi...
Fabric can pull data from onprem database.
So you can create a linked server between analysis instance and database instance and query the SSAS data from database via fabric :
https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/