Forum Discussion

Manar's avatar
Manar
Helper II
8 years ago
Solved

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...
Need Help
  • Manar's avatar
    Manar
    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.

     

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there.

You will have to create the data source in the Manage Gateway's within the Power BI service
Manar's avatar
Manar
Helper II
8 years ago

GilbertQ   My Company already installed the Gateway, connected it to the Datasource , the issue is when I publish a report using the same Server name and database (Direct Mode), it gives me an error meesage : " we were unable to find gateway"  

 

  • Manar's avatar
    Manar
    Helper II
    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.

     

    • LuisGRG's avatar
      LuisGRG
      Frequent Visitor
      3 years ago

      Very good contribution. it helped me a lot.😁

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago
      Great work. Glad it's working