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