Forum Discussion

Data-Crunch's avatar
Data-Crunch
Helper I
1 year ago
Solved

Azure SQL Connection on Gateway cannot be used

Hi community I have a report for which I connected to Azure SQL in Power BI Desktop and I was able to authenticate normally using Basic Credentials while being in the VPN (Due to firewall settings)....
Need Help
  • Data-Crunch's avatar
    Data-Crunch
    1 year ago

    Hi blopez11
    Thanks for the help, I figured out what the problem was! The port which I had added at the end of the string (not visible in the screenshots since I blacked it out, sorry!) seemed like it provoked that behaviour. So note to self: Azure SQL in the Gateway with Port does not seem to work, at least it does have problems recognizinig it as such...
    Without the port I can add the cloud connection and use it just fine.

Data-Crunch's avatar
Data-Crunch
Helper I
1 year ago

Hi blopez11 Thanks for the reply, no unfortunately it only shows the other connection, which is indeed a cloud connection but not a SQL Instance on Azure:

 

blopez11's avatar
blopez11
Super User
1 year ago

In the "Gateway and cloud connections" section, maybe toggle the "Use an On-premises or VNet data gateway"  button to Off.  If not, can you send a screenshot of the whole "Gateway and cloud connections" section?