I have a query using in azure log analytics using Azure Directory Integrated authentication.
evaluate sql_request(
'Server=tcp:somedb.database.windows.net,1433;'
'Authentication="Active Directory Integrated";'
'Initial Catalog=sometable;',
'SELECT * from [dbo].[sometable]'
)
It kept failing with this error and network traces shows a 502 error.
We have experienced a connection issue while retrieving data.
This is usually an indication that the network is down or a firewall or browser extension (such as an ad blocker) is mistakenly preventing access.
I've already added all Application Insights IPs to database's firewall.
https://docs.microsoft.com/en-us/azure/azure-monitor/app/ip-addresses#application-insights-api
