Forum Discussion
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)....
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.
The first screenshot is cut off. So you do not have the option to create a cloud connection in the model settings?