Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi there,
I have installed and built the gateway for an on-premises gateway using SQL Server and although the gateway connection is working I can't get my report refreshed.
I have checked a few MS articles about this, and even done everything over again, and still not workinggateway on pbi services
gateway
gateway on the dataset
error message
Any ideas?
Hi Jinwei, thanks for the advice.
The actual problem was how the queries were stored in Power BI.
Got it sorted already, thanks!
Hi @nelson777 ,
The reason of your issue is an existing connection was forcibly closed by the remote host. Based on the error information you provided, we recommend you to follow the following aspects to troubleshoot.
• To fix this issue, make sure that both the client and server involved in a connection are running Windows that have the leading zero fixes for TLS_DHE installed. It's recommended to install the updates since they enhance the conformance to TLS_DHE specifications.
• Is the firewall turned on in the server that installing SQL Server?
You can refer to this article.
We have found a similar thread for your reference.
Best Regards,
Jinwei Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 72 | |
| 59 | |
| 27 | |
| 23 | |
| 20 |