topic Re: Connecting fabric with On-Premises SSAS Cubes in Dataflow

Connecting fabric with On-Premises SSAS Cubes

Chelly — Thu, 04 Apr 2024 08:40:23 GMT

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?

Re: Connecting fabric with On-Premises SSAS Cubes

Anonymous — Thu, 04 Apr 2024 09:20:58 GMT

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.

Re: Connecting fabric with On-Premises SSAS Cubes

NandanHegde — Fri, 05 Apr 2024 03:31:36 GMT

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/

Re: Connecting fabric with On-Premises SSAS Cubes

Anonymous — Fri, 05 Apr 2024 09:16:47 GMT

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 .

Re: Connecting fabric with On-Premises SSAS Cubes

Anonymous — Mon, 08 Apr 2024 09:43:45 GMT

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.

Re: Connecting fabric with On-Premises SSAS Cubes

Chelly — Mon, 08 Apr 2024 10:32:40 GMT

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

Re: Connecting fabric with On-Premises SSAS Cubes

Anonymous — Mon, 08 Apr 2024 10:39:41 GMT

Hi Chelly ,

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