Forum Discussion
On-premises gateway issue
Good morning,
the Microsoft support team suggested us to downgrade the gateway to an older version (October 2024).
With that version, we didn't faced the 9518 error anymore.
Hi DiegoPLAB ,
Thanks for reaching out to the Microsoft fabric community forum.
After a failure, try restarting the "On-premises data gateway" service this often restores connectivity.
Please go through the below documents which may help you in resolving the issue:
On-premises data gateway in-depth - Power BI | Microsoft Learn
Troubleshoot the on-premises data gateway | Microsoft Learn
Have you tried to unintall and re-install the latest version of the enterprise gateway?
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Menaka.
Community Support Team
Hi v-menakakota,
unfortunately me and my colleagues aren't admin of the gateway, since it was installed by the owner of the SQL Server local machine. So, we aren't able to restart on reinstall the gateway by ourserlves.
We asked him to restart the gateway some days ago, but this not solved the problem.
We are going to check the documents you shared and try other solutions.
Thanks.Hi DiegoPLAB ,
We really appreciate your efforts and for letting us know the update on the issue.
Make sure the linked service for the SQL Server source is using the correct self-hosted integration runtime (matching the gateway you have installed).
If you're copying multiple tables in a single activity or pipeline, consider breaking it down into smaller parts to reduce resource demand.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards,
Menaka.
Community Support TeamHi v-menakakota,
we don't think it's a resource consumption problem in our capacity, as you can see above in the reply to Srisakthi.
In that reply, you can see the exact error message. Everithing appears to be correctly configured and active/online (both gateway and connection) in the Fabric connections page. But when we test the connection inside an activity, the test fails with error 9518.