Forum Discussion

Richard Merckling's avatar
Richard Merckling
Copper Contributor
Nov 10, 2017

Importing Data From Sharepoint List (Site) - Cannot Access Data

Hello all,

 

In Excel 2010, I have selected the Power Query Tab > (Get External Data) From Other Sources Button > From Sharepoint List Button. Entered my site's URL and am prompted with 3 options: Anonymous, Windows or Microsoft Account. 

 

On this Microsoft link, it states that there should be a 3rd option, Organizational Account:

https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777-82ce-b4ed04dedaaf#ID0EAADAAA=2010-2013

 

This seems like the option I would need considering an Organizational Log-in is required to access this site.

 

Is there a way to link my Organizational log-in to the Microsoft Account option? If so, when I click on Sign In from the Microsoft Account Option I receive this error "The WWW-Authenticate header doesn't contain a valid authorization URI. Header value: 'NTLM'."

 

Help is greatly appreciated, thanks so much.

 

-Rich

No RepliesBe the first to reply

Resources