Forum Discussion
Connecting fabric with On-Premises SSAS Cubes
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/
Hi Chelly ,
Thanks for using Fabric Community.
Did you got a chance to look into this documentation - How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn
Supported On-Prem Connectors:
Is the above documentation helped to sort your issue? Otherwise please let me know with further details I will try to help you out.
Additional Docs to refer - Solved: Connect to on-premise SSAS tabular cube with domai... - Microsoft Fabric Community
I hope we provided some insights on your query.
Hello Chelly ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .Hi Chelly ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.Hello, thank you for your assistance. I haven't tested it yet. I'm currently researching the best approach before we begin the project.
