Forum Discussion
Connection to Azure DB requesting Gateway for Power BI Service
Apologies if there is a thred answering this already. I could not find one. We have several reports that connect to an Azure SQL DB without a data gateway (from what I have read, this is perfe...
Hello Anonymous
Use of set server firewall for the Azure SQL DB is for security purpose we need to do that as our IP Address changes as mentioned in the error.
open the azure portal click on the Database click on the set firewall and click on the Add client IP and save it.
IF YOU LIKE MY ANSWER PLEASE ACCEPT IT AS A SOLUTION AND GIVE KUDOS
Regards,
Nimai
Hi Nimai123
I tried this but still get the same error. I still don't fully understand the need for this. My client already has access to the DB. I can import data from DB and flat file without issue. The challenge is getting the PBI service to refresh from the cloud DB and a flat file from a local network via data gateway.