Connect PowerPivot in Excel to LightSwitch oData service RRS feed

  • Question

  • Hi,

    I have an oData source created by LightSwitch hosted on an MS Azure web site. The data source has form (or Basic) authentication. I can connect to the data source using a browser without problem (I do have to complete a login popup). We can also connect to it using our own application.

    I need to expose some data to PowerPivot in Excel. When I configure the data connection, I select Basic in the advance setting and enter the userid and password, but the server is still returning an 401 error: user not authorized. 

    All the answers I found in the forum explains how to connect to an oData source that does not have security. I did find other threads with similar questions, but again no one really explained how to configure PowerPivot in this context or confirm that it can't be done.

    Any help will be appreciated.


    Saturday, October 26, 2013 10:38 PM


All replies