locked
Can't connect CRM DataFeed to PowerPivot RRS feed

  • Question

  • Hi,

    I am trying to connect a hosted CRM 2011 installation to Excel PowerPivot to the Odata feed. Could this be caused by a security setting on the SQL-server?

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

    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:
    ============================

       at Microsoft.AnalysisServices.Common.DataSourceBasic.UpdateDataFeedParameters(ConnectionStringBuilder connBuilder, IDataSource dataSource, Boolean checkFeedValid)
       at Microsoft.AnalysisServices.Common.DataSourceBasic.GetCurrentConnectionString(Boolean checkFeedValid)
       at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

    ============================

    Best regards

    Tuesday, April 8, 2014 3:47 PM

All replies