Forum Discussion
Post ProdigyConnection failed using a Folder connection in a pipeline
Hi,
the gateway's service runs as a NT SERVICE\username. This user has added to the shared folder with the read and write permissions, both NFTS and share, unsuccessfully.
The internal ping has returned ::1, but the IPv6 network card was disabled.
I've tried to specify the IP returned from Resolve-DnsName powershell command, record A, not the hostname, unsuccessfully.I've solved using an existing file server in the same network having a folder already reachable from a Fabric folder connection; also for this server, the internal ping has returned ::1, the only difference is that it is a server external to the gateway.
Thanks
Hi pmscorca
Thank you for reaching out to the Microsoft Fabric Forum Community.
Maybe the issue happens because the gateway is resolving the server name (hostname) to ::1 (IPv6 loopback), so it ends up trying to access itself instead of the actual shared folder. To fix this, use an IPv4 path or a fully qualified domain name instead of the hostname, for example, \\192.168.x.x\CSV-files or \\hostname.domain.local\CSV-files. If the gateway is running on the same server as the folder, you can also just use the local path C:\CSV-files. This avoids the incorrect resolution and lets the pipeline access the files properly.
If there are any deviations from your expectation please let us know we are happy to address.
Thanks.
Post ProdigyHi, thanks for your reply.
The CSV files to get are deposited on the OPDG server.
I've already tried to follow your suggests: using \\hostname.domain.local\CSV-files as a full path I've the same error; using C:\CSV-files I've that the access to this folder is not allowed.
I repeat that when I use a similar folder connection by Power Automate with the same parameters and the same ODPG machine, it doesn't occur any errors.
Is using the OPDG to deposit CSV files to get a problem as a practice to apply or not?
Thanks
- lbendlin
Super User
Is using the OPDG to deposit CSV files to get a problem as a practice to apply or not?The recommendation is to not do that. Gateway VMs should not have any other function. File servers and database servers should reside on separate VMs or physical machines.
- pmscorca
For which reason?
- lbendlin
In simple terms - the gateway configuration states that ALL the memory on your VM is available to mashup containers, and the gateway WILL use that. (Even if you set the memory percentage lower - that setting will be ignored). So any other service will suffer from memory starvation.
Hi pmscorca
Thank you for reaching out to the Microsoft Fabric Forum Community.
lbendlin Thanks for the inputs.
In addition to the user's suggestions, please also try the below.
May be the issue is that in Microsoft Fabric, pipelines access the folder using the gateway’s service account rather than the connection credentials. So even if your user has access, the gateway might not.
please try update the On-Premises Data Gateway service to run under a user (for ex, hostname\fabric-user) that has permission to C : \CSV-files, and then restart the gateway.
If there are any deviations from your expectation please let us know we are happy to address.
Thanks.
- pmscorca
Hi,
the gateway's service runs as a NT SERVICE\username. This user has added to the shared folder with the read and write permissions, both NFTS and share, unsuccessfully.
The internal ping has returned ::1, but the IPv6 network card was disabled.
I've tried to specify the IP returned from Resolve-DnsName powershell command, record A, not the hostname, unsuccessfully.I've solved using an existing file server in the same network having a folder already reachable from a Fabric folder connection; also for this server, the internal ping has returned ::1, the only difference is that it is a server external to the gateway.
Thanks
Hi pmscorca
Thanks for the update. glad your issue is resolved. If any of the replies helped, please mark the most useful one as the accepted solution so it can help others facing a similar problem.
