Troubleshooting scheduled refresh for Azure SQL Databases in Power BI
For detailed steps on setting up scheduled refresh, be sure to see Refresh data in Power BI.
While setting up scheduled refresh for Azure SQL Database, if you get an error with error code 400 during editing the credentials, try the following to set up the appropriate firewall rule:
- Log into your Azure management portal
- Go to the Azure SQL server you are configuring refresh for
- Turn on 'Windows Azure Services' in the allowed services section
More questions? Try the Power BI Community