On-prem SSAS and Fabric

[mtitsworthsfmfb]

Trying to pull data using ADF or notebooks from on-prem SSAS to Fabric. Looks like there is no gateway connection available currently (just SQL server). The current work around is to publish the connection with Power BI and then using semantic-py to grab the data. 

Is there another way? Will on-prem SSAS connectors be available in dataflows soon? 

[NandanHegde · Accepted solution]

Hey,

Please follow the below blog :

https://datasharkx.wordpress.com/2021/03/15/refresh-ssas-tabular-model-from-azure-data-factory/

As of today data pipelines doesnt support Gateway but Dataflow gen2 does support, so you can leverage dataflow gen2

[v-cboorla-msft]

Hi @mtitsworthsfmfb 

Just following up to see whether the given suggestion helps or checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

[mtitsworthsfmfb]

Multidimensional. 

[v-cboorla-msft]

Hi @mtitsworthsfmfb 

Thanks for uisng Microsoft Fabric Community.

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

[AndyDDC]

Is it onprem Tabular or Multidimensional?

[mtitsworthsfmfb]

Multidimensional.