Access Denied by Business Data Connectivity

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. […]