Forum Discussion
Connect PowerBI to Azure SQL Database through on prem gateway
Did you choose to allow your cloud connections to be served by the gateway?
That test is not always conclusive. Better verify with a real data transfer.
Thanks. This setting on the gateway was not enabled so we enabled both, however, I'm still unable to select the new connection.
The new connection was created as an "On-premises" connection.
Was the connection test in the gateway successful?
Yes, the connection in the gateway was successful.
how did you test that? Did you install Power BI Desktop on the gateway VMs and created a successful connection from that?
When you setup the connection on the Gateway, there's a checkbox that says "Skip Test Connection". We did not check this box so our assumption is, it runs a test before creating the connection otherwise it won't allow you to create the connection.