Forum Discussion
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