SQL Server Connects but don't refresh report

[nelson777]

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 servicesgatewaygateway on the dataseterror message

Any ideas?

[nelson777]

Hi Jinwei, thanks for the advice.

The actual problem was how the queries were stored in Power BI.

Got it sorted already, thanks!

[v-jinweili-msft]

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.