Forum Discussion
Power bi gateway error sql server name
Hi Anonymous ,
Would you please try to use server name like: <computer_name>\<instance_name>? Please confirm if the TCP IP is enabled and sql server browser service is running in SSCM.
The link between your dataset and the data source within the gateway is based on your server name and database name. These names must match. For example, if you supply an IP address for the server name within Power BI Desktop, you must use the IP address for the data source within the gateway configuration. If you use SERVER\INSTANCE in Power BI Desktop, you must use it within the data source configured for the gateway.
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
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