Forum Discussion
Get Data from Folder on SharePoint - tied to User
Use the sharepoint file connector instead of the file:
The error comes because the query path uses your local drive to pull through the sharepoint.
The smple file you can select out of the folder and edit to the format you need it in prior to mearging all the files. Select just one of the files you are trying to merge to show it what to look for.
I would have them try to go to the URL it's having the issue with in a browser and see if they actually do have access. The sample query is kind of like the template it uses to understand the data structure - so it looks at that one and then uses that structure to expand the rest of the files in the query. It's normal for it to be there, but the person will need read access to the file to run the refresh.
SharePoint permissions are weird, what could have happened is someone shared via a sharing link, which actually doesn't grant access to the files, it just gives you access via that specific generated URL (and that type of sharing link doesn't work for these queries, it uses the literal path). So, have them try the link it's complaining about, and if they get a permission error on that go in and share the folder... but instead of using a sharing link go to the advanced options and actually grant them read access there - usually it's in the ellipsis menu in the share window. OR just add them to the site visitors group for access to the whole site, with the SharePoint stuff it's better to not try to micromanage the permissions if you can avoid it.