Forum Discussion
Unable to configure Data Source in Data Gateway
I figure out where to remove the data source name. It is on the right hand side hidden next to the data source name. Thanks.
Community SupportHi BrianHo168
"I installed the On-premises Data Gateway on my server behind the firewall. The data gateway is NOT installed on the SQL database server. Do I need to install the On-Premises Data Gateway on the database server. "
You need to install the the On-Premises Data Gateway on the database server.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the advise. Will install the Data Gateway on the database server then try again.
- edhans
Community Champion
Installing on the SQL server should not be necessary. In fact, it cannot be necessary if you install 2+ gateways as part of a cluster to maximize availabilty. You need to figure out the root cause.
IMHO it is not advisable to install on the SQL server itself as the gateway app can be a bit of a resource hog when processing requests from the service, and that can impact the performance of the SQL server itself. The Gateway will send nice and tidy SQL statements to the server, which the SQL server will quickly process and send the relevant data back. The Gateway will then process all further transformation commands locally that cannot be processed by the SQL server (transformations not supported by the server, or mashups from other sources.) and sends the final blob of data back to the PBI Service.
By installing it on the SQL SErver itself, you've put 100% of that workload on that one server.
Thanks for your advise.
I install the On-Premise Data Gateway to a differebt server which acts as a gateway to connect to my SQL dataserver internally.
Now, I run into a different issue which I cannot remove the data sources under the Gateway Clusters. The Server and Database fields are grey out and would not allow me to make changes. There is no option to remove the data source name neither. How can I remove the invalid data sources then replace with one which points to the different server?
