PowerPivot and LS OData RRS feed

  • Question

  • I am trying to connect to a LS oData service using power pivot . The oData security uses forms authentication. In the advanced settings I have supplied the LS username (User ID) and password. However when I test the connection I get the following error. Any suggestions?

    Error Message:

    Cannot connect to the specified feed. Verify the connection and try again. Reason: The remote server returned an error: (401) Unauthorized.

    Call Stack:

    Wednesday, January 2, 2013 9:53 AM

All replies

  • can you connect via the browser:

    http://localhost/ApplicationData.svc {assuming you use http and your service is deployed on localhost}

    Note that the name of the service is case sensitive.

    paul van bladel

    Thursday, January 3, 2013 1:53 PM
  • Hi Paul,

    Thanks for responding. I can connect via the browser. I am prompted for the username and password, I enter my Lightswitch username and password and I get xml in the browser listing the tables that my credentials have access to. I just cannot get to connect with power pivot.



    Thursday, January 3, 2013 6:06 PM