How to Fix "Failed to Retrieve Shared Data Source" Error in Bold Reports Report Viewer

When using the Bold Reports Report Viewer to load an SSRS report, you may encounter an error message stating “Failed to Retrieve Shared Data Source.” This error typically occurs when the user attempting to retrieve the Data Source from SSRS lacks the necessary permissions. Fortunately, resolving this issue is relatively straightforward. In this article, you will be guided through the steps to grant the required permissions and overcome the error.

1. Open the folder containing the Data Source in the SSRS Report Server.

• Access the SSRS Report Server by navigating to the appropriate URL in your web browser.

• Locate and open the folder that contains the Data Source used by the report.

  

2. Click the Manage Folder Option.

• Once inside the desired folder, click “Manage Folder” located in the upper right corner of the Report Server interface.

• This will allow you to modify the folder’s settings and permissions.

  

3. Navigate to the Security Settings.

• In the Manage Folder window, locate and click on the “Security” option.

• By accessing the security settings, you can manage the permissions for the selected folder.

• To resolve the issue, add or modify the user’s permissions within the folder.

• Click “Edit” depending on your required user.

  

4. Assign Appropriate Permissions.

• Ensure that the user or group is assigned to the “Content Manager” role, which includes the necessary permissions for retrieving the Data Source.

• Apply the changes to save the new permissions.

  

5. Provide the permission for the Data Source itself also, as sometimes users may have permissions for the folder but not for the Data Source.

• Click “More info” for the desired Data Source and select the Manage option.

  

6. Navigate to the Security Settings.

• In the Manage window, locate and click on the “Security” option.

• By accessing the security settings, manage the permissions for the selected Data Source.

• To resolve the issue, add or modify the user’s permissions for the Data Source.

• Click “Edit” depending on your required user.

  

7. Assign appropriate permissions.

• Ensure that the user or group is assigned to the “Content Manager” role, which includes the necessary permissions for retrieving the Data Source.

• Apply the changes to save the new permissions.