Forum Discussion
Helper IGateway for Azure SQL Server
Hi mohit_K ,
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,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.-
Hi mohit_K ,
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,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.