Connecting Power Query to SharePoint Foundation 2010

I'm looking to set up PowerQuery in Excel 2013 to link into the various lists on our SharePoint 2010 Foundation server.

I have established the connection URL.

The SharePoint Foundation 2010 server is on the same LAN I'm connected to, so I've opted for Windows Authentication.

These two aspects of the setup appear to be fine: However at the point when Power Query links to the SharePoint server the following error is being returned.

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

Any ideas?

March 17th, 2015 8:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics