Forum Discussion
Anonymous
1 year agoNot applicable
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 ...
- 1 year ago
Did you choose to allow your cloud connections to be served by the gateway?
- 1 year ago
That test is not always conclusive. Better verify with a real data transfer.
lbendlin
1 year agoSuper User
Did you choose to allow your cloud connections to be served by the gateway?
Anonymous
1 year agoNot applicable
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.
- lbendlin1 year agoSuper User
Was the connection test in the gateway successful?
- Anonymous1 year agoNot applicable
Yes, the connection in the gateway was successful.
- lbendlin1 year agoSuper User
how did you test that? Did you install Power BI Desktop on the gateway VMs and created a successful connection from that?