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

Question

My requirement is as belowSource: 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.&nbsp;&nbsp;Thanks,Gnaneshwar

ibarrau · Answer

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:&nbsp;https://learn.microsoft.com/en-us/power-bi/enterprise/onelake-integration-overview
I hope that helps

gnaneshwarm · Answer

Thanks ibarrau,&nbsp;My intention is that Client is using SSAS + Power BI, we would need to recommend him to come to Fabric.&nbsp;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.&nbsp;&nbsp;Any help here.&nbsp;

ibarrau · Answer

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:&nbsp;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:&nbsp;https://www.youtube.com/watch?v=GPf0YS-Xbyo
I hope that make sense

gnaneshwarm · Answer

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

nandanhegde · Answer

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/

Forum Discussion

Related content

Can't Connect Fabric Core MCP Server

Unable to Connect to Analysis Services from Power BI Report Server

Cohort analysis

Connecting to data source failed in Analysis Services live connection

Problem connecting to report server