SharePoint View BCD List get the error "Login failed for user "NT AUTHORITY\ANONYMOUS LOGON"

The reason is the BDC is created from SharePoint designer and the authentication mode is set to "Connect with user's identity"

If enable the BDC with RevertToSelf to true, then the authentication mode can be set to "BDC identity"

Run the following PS command to set the BDC RevertToSelfAllowed to true.

$bdc = Get-SPServiceApplication | where { $_ -match "Business Data Connectivity Service" }
$bdc.RevertToSelfAllowed =$true
$bdc.Update()