Question
JIckes on Mon, 21 Jan 2013 19:50:20
I have a PowerPivot File published to a PowerPivot gallery on SharePoint, here:
http://home.company.com/sites/hcs/BI/PP/PowerPivot Gallery/POG.xlsx
When I try to use this PowerPivot file as a SQL Server Analysis Services Data Connection I get the following error:
Failed to connect to the server. Reason: The following system error occurred: Invalid class string
The following system error occurred:
What am I missing here?
Thanks!!
Sponsored
Replies
Elvis Long on Wed, 23 Jan 2013 02:29:42
Hi JIckes,
In this case, could you please help to collect ULS logs to us for further investigation? We can use UlsViewer, which is a handy tool available at http://code.msdn.microsoft.com/ULSViewer
Furthermore, it seems that you want to use a PowerPivot file from client application(Such as Excel). If you can describe your environment with more detail, it will benefit for us to reproduce this issue. So, it can be difficult to determine where the problem
lies. But I recommand you take a look at the following article:
Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication:
http://blogs.msdn.com/b/johndesch/archive/2012/04/23/using-powerpivot-workbooks-from-a-mid-tier-server-configured-for-kerberos-authentication.aspx
Regards,