Forum Discussion
Connecting to SharePoint Folder error
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
- Can you share the URL which you copied in the source
- Which authentication are you using?
- which privacy settings you are applying to?
Hi
1. https://isharenew.###.com/sites/sitename##/ (on premise 2016)
2. Windows (current credentials)
3. All privacy settings attempted.
These settings work for SharePoint lists and web connection in the same SharePoint site.
Try to enter your Windows credentials along with your domain name.
example- abc\username
Also, try OAuth 2.0 authentication.
Still not working, i dont have OAuth 2.0 as an option either