Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Having trouble using an On-premises Data Gateway to copy files from SharePoint Online to my local server.
I have an existing connection setup that works, finding files that are copied through a local script to a "C:\SSC\" folder daily, to use Power Automate (through the Data Gateway) to move those files up to SharePoint Online.
I am trying to create a new Power Automate flow that also copies files from a SharePoint Online Document Library down to a different path on this same server (D:\Works\).
Setting up new connectors in Power Automate, I continously get failures running the flow that reference "Action 'Create_file' failed" due to "status 403 the credentials for this connection do not have access to the path - try using a different location or account".
My flow is created using a domain service account. My Data Gateway Administrator is the same service account. I have file share permissions all setup for full read/write to the D:\Works path and can manually navigate to the path and manipulate files when signing into the server using the service account.
I have tried different folder paths in my Power Automate Flow (create file action) to test, and they all fail with the same error. UNC is the one I would expect to work: \\SRVservername\Works
I have also tried sharing out the folder on the server and \\SRVservername\Works$ still fails with the same error.
Trying all the connectors available through a new Power Automate Flow, I did stumble on one that did not immediately error out. Testing that connector I was able to save a file to C:\SSC\SRVservername\Works\, even though I had still only specified
\\SRVservername\Works in the flow folder path. The connector is my existing, original, working connector, which apparently defaults somehow to C:\SSC???
How can I get a second connector setup using this same gateway and have it work, but to a different local server path?
Where can I find this default path "c:\SSC" that is specified and would I even want to consider changing it if my original connector is working as expected?
What else should I be asking to help resolve this situation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.