How to connect to Azure Serverless Pool from On-Prem SSAS Tabular using Visual Studio

Cabral, Scott 21 Reputation points
2023-07-10T13:23:10.4766667+00:00

Hi,

We have an On-Prem SSAS Tabular database and we need to be able to setup a new datasource to an Azure Serverless SQL Pool. I tried all the different providers but there doesn't seem to be a way to connect. Using SSMS, I can connect using Azure Active Directory - Universal with MFA but that option doesn't exist in Visual Studio when creating a new connection

thanks

Scott

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
438 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sedat SALMAN 13,160 Reputation points
    2023-07-10T18:56:11.6766667+00:00

    You might want to consider setting up a VPN or ExpressRoute from your local environment to your Azure SQL Server to help secure the connection and bypass the MFA for your system

    https://learn.microsoft.com/en-us/azure/expressroute/expressroute-introduction

    https://learn.microsoft.com/en-us/azure/expressroute/about-public-peering#compare

    0 comments