Search code examples
wcfweb-servicesauthenticationodatapowerpivot

Writing a Secure WCF Data Service for Excel PowerPivot

I'm having some trouble writing a secure WCF data service to be consumed by PowerPivot. The service works fine, and I can consume the data in PowerPivot without trouble.

My issue is that when I enter the user ID and password for the Data Feed in PowerPivot (in Data Feed advanced settings), I can't seem to get any access to them from inside the WCF service. I'd like to use both the user ID and password to authenticate against a database, but I need to get at them first. :)

Are there any good examples of how to write a secure WCF Data Service specifically for PowerPivot?

Thanks very much.

Solution

  • I was struggling with this same thing, and after some research found this blog post that got me rolling:

    http://pfelix.wordpress.com/2011/04/21/wcf-web-api-self-hosting-https-and-http-basic-authentication/

    In short, there is some work you need to do to allow the Principal to flow through to the service call.