Forum Discussion
Connect PowerBI to Azure SQL Database through on prem gateway
I have a report that uses Azure SQL database as a datasource. I want to setup a scheduled refresh, but we do not want to expose the Azure SQL database to the public internet. We tried using the on ...
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.
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.
That test is not always conclusive. Better verify with a real data transfer.