Forum Discussion
Power BI gateway personal mode to refresh Azure SQL DB data source? is it possible?
Hi, my company requires gateway to refresh Power BI report connected to Azure SQL DB. I cannot use standard mode gateway so I would like to try with personal mode. however gateway do not show in re...
yes I am aware of it but no gateway option is blocked by DB firewalls policy.
I don't understand what you mean with the last sentence. Be sure that the Azure SQL DB Firewall accepts azure services or microsoft ip list if you want to connect. You should also add the VM public ip.
The answer would be Yes. But pay attention, you can only configure a Personal Gateway to connect Azure SQL DB if you are Importing Data. You can't use direct query with personal option.
Regards,