Troubleshooting Sharepoint: The data source no longer exists or you do not have permissions to view it.

  • Article

Issue

While using Performance Point’s Dashboard Designer, the following error appeared: "The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator."

Error details

Exception Details: The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator.

Inner Exception Message:Stack Trace: at Microsoft.PerformancePoint.Scorecards.Server.PmServer.ExecuteAnalyticReportWithParameters(RepositoryLocation analyticReportViewLocation, BIDataContainer biDataContainer)

at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.ExtractReportViewData()

at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.CreateRenderedView(StringBuilder sd)

at Microsoft.PerformancePoint.Scorecards.ServerRendering.NavigableControl.RenderControl(HtmlTextWriter writer)

Performance Point Services error code 20604.

Cause

The Performance Point is not working as expected for many reasons.

Solution

 Ensure to check the below to work the Performance Point service as expected.

  1. Performance Point doesn't support claims-based authentication.
  2.  Make sure the account you use to logon the server has proper permissions to the data connection list since when SharePoint opens dashboard designer from the client side, it uses the current account of the server and not the current account of the SharePoint site.
  3. Ensure the web app pool identity has permissions to connect to Performance Point service application.
  4.  Ensure to configure the unattended service account
  5.  http://technet.microsoft.com/en-us/library/ee836145.aspx
  6. The service account that runs the IIS app pools had to be added as a reader in the BI Center.

See also