Forum Discussion

gnaneshwarm's avatar
gnaneshwarm
Frequent Visitor
2 years ago

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

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 Analysi...
Need Help
gnaneshwarm's avatar
gnaneshwarm
Frequent Visitor
2 years ago

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's avatar
ibarrau
Super User
2 years ago

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