CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services

Error trying to access SharePoint List from Power Query

Error trying to access SharePoint List from Power Query

Rate This
  • Comments 1

When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID, you may see the following output in your query:

SNAGHTML6ca120d

DataFormat.Error: OData: The given URL neither points to an OData Service or a feed: ‘https://login.microsoftonline.com/login.srf?wa=wsignin1.0&rpsnv=2&ct=1375471406&rver=6.1.6203.0&wp=MBI&wreply=<URL>&lc=1033&id=500046&guests=1’.

You may also see an error saying “The user was not authorized”.

SNAGHTML6af584f

You may see one of these errors when you do not select “Keep me signed in” when logging into O365.

SNAGHTML6c95faf

After putting the check in “Keep me signed in”, you should then see the proper output.

SNAGHTML6c9a23b

Adam W. Saxton | Microsoft Escalation Services
http://twitter.com/awsaxton

Leave a Comment
  • Please add 3 and 5 and type the answer here:
  • Post
  • We are using the desktop version of Office so we don't connect in the same manner as Office 365 users. Any ideas of how to fix the problem for the desktop users of Office 2013?

Page 1 of 1 (1 items)