How to resolve An error occurred while retrieving data from “”. Administrators, see the server log for more information. in SharePoint Online?

Hello SharePointers,

If you face the below issue while using external data type column in your project to fetch information from external system

“An error occurred while retrieving data from ResourceHub-Prod. Administrators, see the server log for more information”

Here is the resolution for you.

  1. This is security/Permission issue
  2. you need to set navigate to SharePoint admin center
  3.  Click on BCS settings
  4. Click on Manage BDC Models and External Content Types
  5. Look out for your required BDC Model and then select Set Metadata store permissions to Execute for all the membership group
  6. Click on Secure Store Stettings
  7. Select the required Target Application ID
  8. Click Edit and Add the required groups for example (Everyone except external users)  to Target members group.

This will resolve your permission issue and you can select your external fields 🙂

Happy SharePointing 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *