Forum Discussion

jesse_james's avatar
jesse_james
Helper I
5 years ago

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...
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

You do understand that even if this is possible or not you are downloading data from azure to local and uploading again to power bi instead of just connecting your credentials in Power Bi directly to Azure SQL DB, don't you?
I would strongly recommend to just enter the credentials in the schedule refresh configuration of the report and try to connect without the gateway. Otherwise you might need an Azure VM to install a personal gateway to be the bridge with between DB and Power Bi because if you have it locally is way too overkill.

Regards,

jesse_james's avatar
jesse_james
Helper I
5 years ago

yes I am aware of it but no gateway option is blocked by DB firewalls policy.

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    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,