Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

PerformancePoint Services PowerPivot Data Sources Error

Posted by denglishbi on July 21, 2010

So I was working on a PerformancePoint 2010 dashboard and making really good progress.  I then ran had to add a new source into a PowerPivot (Excel 2010) file and the source was a SharePoint 2010 list.  I went out to the SharePoint list and clicked on the Export as Data Feed option in the SharePoint Ribbon List options.  When I pulled this atom feed into PowerPivot I ended up receiving an error message (even though the connection tested out okay) stating

“For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method”

So I checked the advanced settings of the connection setup, but didn’t see anything related to this.  I then went ahead and did a quick search and came across this posting from Dave Wickert Using a SharePoint list as a data source and realized that when the SharePoint 2010 server was setup that the ADO.NET Data Services 3.5 SP1 hotfix was not installed on the server.  I went ahead and installed this which then required a reboot for the fix to take effect.

When the server was back up I could then proceed with the SharePoint list import into PowerPivot, but then I realized that none of the PowerPivot data sources in PerformancePoint Dashboard Designer were working.

image 

“This action cannot complete because PerformancePoint Services is not configured correctly.  Additional details have been logged for your administrator”

And when I went into a report referencing the PowerPivot source in the designer I got this message:

image

“This action cannot complete because PerformancePoint Services is not configured correctly.  Additional details have been logged for your administrator.”

Interesting since everything was working fine prior to the server reboot.  So I went and took a look at one of the deployed dashboards and noticed that nothing was working.

image

image

Well this isn’t good.  So I checked that the PowerPivot files were accessible in SharePoint and were working properly which there were.  I then check the authentication setup on the PerformancePoint PowerPivot data sources to verify everything was still setup properly.  The data sources were configured to utilize the Per User Identity option.  Typically this might require Kerberos to be configured, but in our case we were using PowerPivot which is claims based aware and this should work…assuming that the Claims to Windows Token Service is actually started (Information on SharePoint Services that need to be started).  So I go ahead and take a look at the services running on the server.

image

Oh no, the service has not started yet.  I go ahead and start the service and retest my PowerPivot data source connections in Dashboard Designer

image

Success!  We are off to the races.

For some additional information on troubleshooting PerformancePoint Services check out this posting here – PerformancePoint Services troubleshooting.

UPDATE (7/21/2010): Kasper de Jonge just notified me about an issue with this service and once again Dave Wickert has a blog posting about it – Help: c2wts has fallen and it cannot get up.  Yesterday I waited for over 10 minutes and it still had not started.  Looking forward to implementing this fix.

Advertisements

6 Responses to “PerformancePoint Services PowerPivot Data Sources Error”

  1. Drew said

    Great Blog. I am still having issue using a list as a data source. I am still receiving this error:

    “For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method”

    I have installed, uninstalled, and reinstalled the ADO.net hotfix with no luck. Any ideas?

    • denglishbi said

      The only thing I can think of is that after you install this on the server you will need to restart the server for this change to take effect. This should definitely resolve the issue of being able to utilize the SharePoint list as a data feed.

      • Drew said

        I have a 3 server farm with a SQL, APP, and WFE server. I have installed powerpivot onto the APP server. I have installed the update on all servers and restarted all servers and I am still receiving the error…

        If you have any other ideas or something I may have missed I am all ears!

      • Drew said

        So I figured it out!

        1. I had to install the ADO.NET Data Services Update for .NET Framework 3.5 SP1 . http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=3e102d74-37bf-4c1e-9da6-5175644fe22d on both my APP and WFE server.

        2. Restart servers

        3. Install ADO.NET Data Services v1.5 CTP2 on both my APP and WFE server. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a71060eb-454e-4475-81a6-e9552b1034fc&displaylang=en

        4. Then the impossible one. I got this error in the WFE event viewer…

        WebHost failed to process a request.
        Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/17653682
        Exception: System.ServiceModel.ServiceActivationException: The service ‘/_vti_bin/ListData.svc’ cannot be activated due to an exception during compilation. The exception message is: Exception has been thrown by the target of an invocation.. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.NullReferenceException: Object reference not set to an instance of an object.
        at Microsoft.SharePoint.Linq.ListDataService..ctor()

        5. I had to turn off “Enable Anonymous Access” for my Web Application

        1.Central Admin -> Application Management -> Manage Web Applications -> Select your web application and choose “Authentication Providers” -> Select your Zone -> Unselect “Enable Anonymous Access”

        SUCCESS!

  2. Greg said

    Funny. Thanks for your help. We were troubleshooting w/ Microsoft last week and dude had us turn it off (C2WTS) and we forgot to turn it back on. Devs called us with the error that you reported … thank you GOOGLE … you were my 2nd click (right after the guy who recommended that you recreate the service account). haha.

    We turned it back on in CA and we’re good to go… thanks for the pointer.

    • denglishbi said

      Glad you resolved your issue. The error messages are not always the greatest, luckily there are bloggers out there that save us when we get caught in a bind.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: