Blog Post

SQL Server Support Blog
1 MIN READ

Error trying to access SharePoint List from Power Query

mssql-support's avatar
mssql-support
Iron Contributor
Jan 15, 2019
First published on MSDN on Aug 08, 2013

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:

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”.

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

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

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

Updated Jan 15, 2019
Version 2.0
No CommentsBe the first to comment