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:
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