Edit

Share via

Troubleshoot scheduled refresh for Azure SQL databases in Power BI

  • Article

This article provides steps to troubleshoot errors encountered during scheduled refresh for Azure SQL databases in Power BI. For detailed information about refresh, see Data refresh in Power BI and Configure scheduled refresh.

While you set up scheduled refresh for an Azure SQL database, if you get an error with error code 400 when editing the credentials, try these steps to configure the correct firewall rule:

  1. Sign in to the Azure portal.

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

  3. On the Overview page, select Set server firewall.

  4. On the Networking page, select Allow Azure services and resources to access this server and choose Save.

A screenshot that shows the Azure allowed services access option.

More questions? Ask the Power BI Community.