Settings Dataset Error

[CurtStep01]

Good Day All

I am stuck and I need your help. I have set up an on premises gateway which is connected and working, i have then added the datasources which are conneced and working. 

When I go to the settings folder on the web, choose dataset and choose the correct report. I then get the option to choose gateway connection and map data sources in the dataset to the gateway sources. The excel connection maps no problem!

My issue is the SQL database gateway source is not recognised, it does not appear on the map dropdown menu. 

I have tried to add the dataset source use the add to gateway option, which i run through and connect but when i jump back through to settings, sql database source still does not appear or be recognised.

Any suggestions?

[v-shex-msft]

Hi @CurtStep01,

It seems like power bi not recognize the localhost service. I'd like to suggest you use your device IP address or server name instead of 'localhost'. SQL - Query to get server's IP address 

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi there

Can you show how you configured the data source for your localhost:1433 in the Manage Gateways?

[CurtStep01]

Hi Gilbert

I managed to get some rest and sort it out this morning. The gateway source would only connect to the SQL database using localhost without the port 1433. 

I changed PowerBi desktop source to 127.0.0.1 excluded the port 1433, made sure the desktop dataset could refresh. Republished and used 127.0.0.1, it accepted and i'm up and running.

The issue was the port connection locally on 1433 and the inability to connect using port 1433 from the gateway source side and just using localhost.