Forms Authentication and Excel PowerPivot OData DataFeed RRS feed

  • Question

  • I am trying to connect to a Lightswitch 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 7:34 PM


All replies