Forum Discussion
Manar
8 years agoHelper II
Gateway issue
Hi, In my company we are trying to connect the Gateway to our datasource which is in a sql server named instance that uses different port (NOT the default port 1433), Every time we try to add the...
- 8 years ago
We solved the issue. Our SQL server is a named isntance so we had to add port number, and the reports were connected to the server without the port number, and that was causing an issue. The name of the server in power bi desktop from which we are pulling the data has to be exactly the same on the Gateway.
GilbertQ Thank you so much for helping out.
Manar
8 years agoHelper II
We solved the issue. Our SQL server is a named isntance so we had to add port number, and the reports were connected to the server without the port number, and that was causing an issue. The name of the server in power bi desktop from which we are pulling the data has to be exactly the same on the Gateway.
GilbertQ Thank you so much for helping out.
GilbertQ
8 years agoSuper User
Great work. Glad it's working