Forum Discussion

Heena_9980400's avatar
Heena_9980400
Helper IV
3 years ago
Solved

Do we required data gateway to refresh data

Hi Experts,   As I am using Azure SQL analytics as a data source for my reports I doubt we require data gateways to refresh data for the azure synapse database, since it's a cloud-based database. ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
v-luwang-msft's avatar
v-luwang-msft
Community Support
3 years ago

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:

  1. Sign in to the Azure portal.

  2. Go to the Azure SQL database for which you're configuring refresh.

  3. At the top of the Overview blade, select Set server firewall.

  4. 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