Hello,
I am having an issue when a new person is using a Power Query Retrieve I created a while ago. It works fine for me and another user but not for anyone new. I may be forgetting a simple step. The query looks for files in a folder below where the spreadsheet is saved. Attached are the relevant error screens. Any ideas appreciated.
Thanks,
Vincent
Hello,
Well, the error message says it all, the user(-s) getting this error lacks permission to access the folder and/or files in the shared folder on \150susi-fs-p1...
Check and update the permission settings for the shared folder and have the user(-s) to login again after restarting the computer, should work fine then.
Br,
Anders
Thanks Anders,
I was confused as I thought the only folder being used was created by the user who could not access it! However further up in the code I found where the secure folder was being accessed, even though it was not actually being used. I fixed this now, thanks again for your help.
Regards,
Vincent