Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

SSAS connection inside VPN

Hello we have a SSAS server inside a VPN.

How we can connect to this server from power bi?

Thank you in advance.

Need Help

5 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Anonymous Provided that machine you've got Power BI Desktop installed is able to talk to VM on which SSAS is you should be ok accessing that SSAS instance. You can also consdier installing power bi desktop on the actual VM hosting SSAS.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      The machine is the same.

      We have power bi desktop and sql server (with ssas) in the same machine.

      The we want to publish the dashboards in the cloud.

      must I use gateway to direct query?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        Do you want to connect to SQL Server Analysis Server(SSAS) database via  “Connect Live” option in Power BI Desktop? If  that is the case, you don’t require a gateway in Power BI Desktop. However, after you publish Power BI Desktop file(PBIX file) to Power BI Service, you would get a warning as follows.


        In order to access the published report in Power BI Service, you would need to install and configure on-premises gateway and add the SSAS data source under the gateway. Otherwise, you will get error message as shown in the following screenshot.

         

        Thanks,
        Lydia Zhang