Scenario:
Getting Error “Access Denied by Business Data Connectivity”, while loading the External List.
Solution:
Go to Central Administration -> Application Management -> Manage Service Applications -> Business Data Connectivity Service
Select the Store and Click on Set Metadata store permissions. […]