Questions about using a webservice as data-source for power-pivot RRS feed

  • Question

  • Hi there,

    we are running a webbased  .NET-Application (Windows Server 2008 R2 || IIS 7.5 || .NET 4.x).

    Now we need to get some datafeeds out of our application's sql-Server (SQL-Server 2008 Standard) right into Power Pivot.

    Because our application and database contains Data belonging to differnt clients, we cannot access the database directly.

    Therefore we build a small svc, to authenticate the user and give him access only to his data. 


    • We have to use username+password as authentification. Is there a way to realize this?
    • And how can we store authentification information outside Power Pivot or a config file?  (i.e save them inside the users profile)

    Thanks in advance,


    Wednesday, July 11, 2012 4:46 PM