Forum Discussion
PBI Gateway Pubic IP and Server Instance Connection
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.
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.
My gateway looks good. It is on the same server as the SQL server. Runs under my O365 login. Not sure what you mean by can it contact the SQL server by IP. It is on that server and shouldplus I don't see in gateway config here where to put that.
My PBI gateway config is where the issue is I think. As you can see when I create datasource it wants the instance name of SQL server and connects. If I put the IP there it will not connect and gives me the message basically saying use the instance name. On my data source it says gateway is not config I guess because my data source was created by IP when I created it on PBI desktop.
So how do I get the datasource in PBI to use the instance name not IP. PBI desktop that looks like to me I where I am off. Am I correct?
Dataset setting - trying to use IP from datasource in my PBI desktop created report
dataset settings
gateway on SQL server looks good to me
gateway on SQL server
gateway on PBI service finds gateway but only connects to my datasource wiht sql server instance name not IP.
datasource on PBI service gateway