Forum Discussion
Do we required data gateway to refresh data
Hi Heena_9980400 ，
According to the official document, Gateway is not required for Azure SQL Database.
While setting up scheduled refresh for Azure SQL database, if you get an error with error code 400 when editing the credentials, try the following to set up the appropriate firewall rule:
-
Sign in to the Azure portal.
-
Go to the Azure SQL database for which you're configuring refresh.
-
At the top of the Overview blade, select Set server firewall.
-
On the Firewall settings blade, make sure that Allow Azure services and resources to access this server is set to Yes.
For more information, please refer to:
Azure SQL Database with DirectQuery - Power BI | Microsoft Docs
Azure SQL firewall settings for Power BI refresh - Dutch Data Dude
Best Regards
Lucien
-
Hey, Assuming the Azure SQL database/ synapse pool is not moved within a Vnet then to refresh powerbi you wont need a gateway as both are cloud resources on public net.
In case if the synapse is within a vnet, you would have to create a server within that vent and install and leverage the gateway