none
PowerView Error: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source.

    Question

  • We have a SharePoint system for Power View, and it was working before the holidays but stopped working after we come back to work today. We have not changed anything in the setup, so we thought there may be something in the system changed that we were not aware of. We are not sure where to start since we don't know what the possible causes are. We'd really appreciate any help to troubleshoot the problem, where to start and what to look for.

    Our system setup is below:

    SharePoint 2010 on Windows Server 2008 R2, SP1

    SQL Server 2012 also on Windows Server 2008 R2, SP1

    The users are on the same domain as the SharePoint and SQL Servers.

    We create all of our reports based on PowerPivot workbooks (not analysis tabular modules)

    I've checked that Analysis Service is running and users have admin access to Analysis Services, and the users have access to the data sources in the PowerPivot workbooks.  

    Appreciate any help that would help us troubleshoot the problem or point us to the right direction.

    Wednesday, January 2, 2013 7:05 PM

Answers

  • It turns out that SQL Server 2012 SP1 was applied on the server, and none of us was aware of it. We had to run the PowerPivot configuration tool to fix the problem. It's up and running again now.

    Thank you all for you help!

    • Marked as answer by May Mason Monday, January 7, 2013 9:30 PM
    Monday, January 7, 2013 9:18 PM

All replies

  • Hi May,

    The error may be caused by Kerberos authentication issue due to missing SPN. In order to make the Kerberos authentication work, you need to configure the Analysis Services to run under a domain account, and register the SPNs for the Analysis Services server.

    To create the SPN for the Analysis Services server that is running under a domain account, run the following commands at a command prompt:

    • Setspn.exe -S MSOLAPSvc.3/Fully_Qualified_domainName OLAP_Service_Startup_Account
      Note: Fully_Qualified_domainName is a placeholder for the FQDN.
    • Setspn.exe -S MSOLAPSvc.3/serverHostName OLAP_Service_Startup_Account

    For more information, please see:
    How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication

    Hope this hleps.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    Thursday, January 3, 2013 9:24 AM
    Moderator
  • Can you verify that you the SQL Server Browser service is running on the machine that has the PowerPivot instance of SSAS?  That is required to be running because of the named instance of SSAS.  If that is not running it could definitely cause this issue. 

    Another way to verify that this is probably the issue is that the PowerPivot workbooks are not working and most likely the PowerPivot Management dashboard in CA is not working either.


    Dan English's BI Blog

    Thursday, January 3, 2013 12:39 PM
  • It turns out that SQL Server 2012 SP1 was applied on the server, and none of us was aware of it. We had to run the PowerPivot configuration tool to fix the problem. It's up and running again now.

    Thank you all for you help!

    • Marked as answer by May Mason Monday, January 7, 2013 9:30 PM
    Monday, January 7, 2013 9:18 PM