Forum Discussion

Karljr's avatar
Karljr
Frequent Visitor
5 years ago
Solved

PBI Gateway Pubic IP and Server Instance Connection

My SQL Server is on a cloud server. It is not on a domain.  I conect to it via a public IP.  SQL server has allow remote coenection on and I can connect to it with the IP via SSMS.  I wrote a PBI rep...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi Karljr 

     

    When configuring the data source it should work via the IP Address as long as your Gateway server can access the SQL Server via the same IP Address.

     

    I would suggest logging into the Gateway server and see how you can connect via the IP Address and which username and password you use.


    Then take those same details and create this in the data source in the Power BI Service under manage Gateways.

Karljr's avatar
Karljr
Frequent Visitor
5 years ago

I figured it out.  Gilbert gave me soem ideas that pointed me in the right direction.  

 

PBI Desktop  I connected via IP address.

PBI Service Gateway needed to connect to datasource with the server name. 

When I published my report/data source it wanted IP but gateway was wanting name. 

So no connect to gateway. 

 

I solved by added a host table entry on my laptop that mapped the IP address to the server name.  

PBI desktop then connected so I can develop and test. 

Then publish it to PBI 

PBI gateway then sees server name and refreshed data from gateway.