Forum Discussion
Power bi gateway error sql server name
Thanks v-deddai1-msft lbendlin for the reply.
The TCP IP is enabled and sql server browser service is running in SSCM.
It is correct that the names should be the same, but this would not work because the name of the server would not be recognized without being in the internal network or being connected to a vpn.
We have used a DNS to forward the incoming IP to the localhost in order to make it work. Alternatively we could have used a VPN to connect to the cloud server but this seemed like a faster solution.
However, right now, the GW just uses extreme CPU resources and does not perform the refresh at all...
Hi Anonymous ,
You may need to configure proxy settings for the on-premises data gateway, please refer to https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai