none
Power Query error connecting to specific SharePoint 2013 site RRS feed

  • Question

  • I have a number of SharePoint 2013 sites. I can connect to all of them in Excel 2013 64-bit with latest copy of Power Query except one. It returns:

    DataSource.Error: OData: The feed's metadata document appears to be invalid.

    Trace log line for the only error I can find:

    DataMashup.Trace Error: 24579 : {"Start":"2015-07-13T13:22:37.5296863Z","Action":"ComWrapper/InvokeMember","MemberName":"Value","Exception":"Exception:\r\nExceptionType: System.Reflection.TargetInvocationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Exception has been thrown by the target of an invocation.\r\nStackTrace:\n   at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)\r\n   at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)\r\n   at Microsoft.Mashup.Client.Excel.Com.ComWrapper.InvokeMember(String memberName, BindingFlags bindingFlags, Object[] args)\r\n\r\nInnerException\r\nHRESULT: 0x80004005\r\nException:\r\nExceptionType: System.Runtime.InteropServices.COMException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL))\r\nStackTrace:\n\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.23.4035.242 (Release-V2-Public)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"excel","Pid":10476,"Tid":1,"Duration":"00:00:00.0071830"}

    I have no idea why this particular SharePoint site is different from the others.

    Monday, July 13, 2015 1:32 PM