Connecting fabric with On-Premises SSAS Cubes

[Chelly]

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 connecting to SQL Server or discussions stating that connecting to SSAS from Fabric isn't currently available. I'm unsure if I'm pursuing the right approach. Any guidance would be greatly appreciated. Would it be sufficient to install a linked server on the machine and utilize SQL Server as the connector?

[NandanHegde · Accepted solution]

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/827...

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/

[v-gchenna-msft]

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.

[v-gchenna-msft]

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 .

[v-gchenna-msft]

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.

[Chelly]

Hello, thank you for your assistance. I haven't tested it yet. I'm currently researching the best approach before we begin the project.

[v-gchenna-msft]

Hi @Chelly ,

Glad to know that you got some insights. Please continue using Fabric Community on your further queries.