Troubleshooting scheduled refresh for Azure SQL Databases in Power BI

For detailed information about refresh, see Refresh data in Power BI and Configure scheduled refresh.

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 access to Azure services is set to ON.

    Azure allowed services

More questions? Try the Power BI Community