Forum Discussion
Gateway issue
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.
Hi Manar
When creating the new data source in the Gateway on the Power BI Service, ensure to put in the Port Number at the end of your server name.
So for example if my SQL Server was called: Datawarehouse.mydomain.com or 10.24.52.11
And my port that I had changed it to was: 5874
When creating the data source in the Gateway in the Power BI Service, where it asks for the Server I would put in the following:
Datawarehouse.mydomain.com,5874
OR
10.24.52.11,5874
Either of the above will work, I tested it on a Gateway now and it registered successfully.
- Unusual it was working for me, so possibly an issue with the firewall or Gateway server?
have you tried setting the Gateway to use HTTPS to see if that works on the server where the Gateway is installed?thank you GilbertQ The gateway was successfully installed on the server and connected to the data source, the issue is every time I publish a report my system doesn't find the Gateway (it tells me no gateway is enabled) Should I do something to my own firewall to allow the enterprise gateway , any clue on why my computer can't find the gateway.
- Hi there.
You will have to create the data source in the Manage Gateway's within the Power BI service