Forum Discussion
Unable to connect to On Prem Analysis server (SQL Server)
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
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.
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
