Unable to connect to On Prem Analysis server (SQL Server)

[gnaneshwarm]

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 Analysis server to Fabric. Can someone please provide a solution or alternative way to achieve this requirment. 

Thanks,

Gnaneshwar

[NandanHegde]

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/

[gnaneshwarm]

Thanks for the reply, I will look into this and confirm back here.

[ibarrau]

Hi. If you just want to read data from your Analysis Services, you can connect a PowerBi live connected published at a workspace with Fabric capacity. If you want to move your data to a Fabric lakehouse at OneLake, then the best practice would be moving the data from the hosted source. That means from the previous source of analysis services. If you have a data warehouse with the dimensional model, take it from there and not from SSAS.

As an alternative if you really need to move it from SSAS directly. My guess is that the only way would be connecting a PowerBi semantic model and use the Onelake integration to take it to the lakehouse. You can read about that feature here: https://learn.microsoft.com/en-us/power-bi/enterprise/onelake-integration-overview

I hope that helps

[gnaneshwarm]

Thanks ibarrau, 

My intention is that Client is using SSAS + Power BI, we would need to recommend him to come to Fabric. 

However when I'm using Power BI Live connection, am able to import tables into Power BI. But when i'm using the same connection in Fabric, it's throwing below error.

Any help here.

[ibarrau]

Hi. The error means that you are missing a configuration over the gateway administration. Live connection means that PowerBi will query directly to SSAS. In order to let Power Bi Service communicate with an onpremise source you must use an onpremise data gateway. This: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

You can also look for walkthroughs over internet for the configuration like this one: https://www.youtube.com/watch?v=GPf0YS-Xbyo

I hope that make sense