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

 

Thanks,

Gnaneshwar

Need Help

5 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    2 years ago

    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'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.

       

  • gnaneshwarm's avatar
    gnaneshwarm
    Frequent Visitor
    2 years ago

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