CODEWITHSUNDEEP
sql-serverpowerbipowerbi-desktoppowerbi-datasourceonpremises-gateway
Sander Vanhemel
Sander Vanhemel

Reputation: 29

On premises gateway PowerBI Service

I'm trying to connect my datasource in power bi service via my on-premises gateway. The on-premises gateway is working perfectly in Powerapps with no connection problems. This is the screen I get to connect them:

enter image description here

When I add to gateway I fill in the data and so on:

enter image description here

When I connect with the port behind it I don't get a connection to the SQL. If I delete the port and I connect I get a connection in SQL. But then the connection string is this: be-gbdps006\sqlexpress and not be-gbdps006\sqlexpress:1433 so I still can't add it to the Gateway. Does someone has a solution to solve this. (also I need this port in power bi desktop otherwise I can't get connected to the SQL and I can't publish it) I hope someone had the same issue and does have solved someway.

Upvotes: 0

Views: 152

Answers (0)

Related Questions