Forum Discussion
Gateway Issue - Credentials Applied to Folder are invalid
Is the gateway set up correctly so the connection shows as valid, not in error?
I'm not a huge fan of using a Gateway for folder access. It is much easier to move the files to a SharePoint file library, so if that is an option, it will save a lot of configuration and grief.
If not, images of your gateway config would help, but keep in mind this is a public forum, and you have some corporate specific info in that screenshot.
Thank you for the reply. I am investigating if we can use sharepoint. Here is the error message which I am getting:
Looks like a permission issue. You will likely need to work with your SharePoint admin to look at the permissions. Power Query needs permissions to the SP site, not just the folder you want. It has to start at the top and navigate to the folder. In the web browser, you can be denied access to the entire site, but still access a folder. PQ doesn't allow that.