March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I created a report in PBI Desktop. The main data source is a SQL Server database on a remote server. In order to connect to that SQL database on a remote server in PBI Desktop, I have to type an IP address and port as a server name.
So I upload the report to PBI Service and let the IT department install the on-premise gateway on the server. Gateway is installed correctly. I go to the dataset settings and under Gateway connection I want to add the data source to gateway
This should be the standard procedure found in all the tutorials. But there is a problem. Because the gateway is installed on the server directly and it is not accessing the server remotely like I do in PBI Desktop, the credentials are different, namely the server name.
I can't type the IP address, it does not work. I have to type the instance, I suppose the reason is that the gateway is installed directly on the server. But there is this rule: The name of your SQL Server instance must be identical to what you specified in Power BI Desktop
However, I don't know how to achieve this. I have to type the IP address and port number 46.xxx.xxx.xxx:pppp in Power BI Desktop but this does not work in PBI Service, I have to type the instance there otherwise it does not connect. And vice versa, I cannot type the instance in Power BI Desktop as the server is remote.
Is there any way how to solve this please?
Solved! Go to Solution.
Hi @Petanek333 - the Server string will need to match how the Gateway is configure, so can I suggest that you create a parameter called "Server" in your PBIX file which contains the IP string. When you publish this to the Power BI Web Service you can change the Parameter to the Server string. The new parameter value should be recognised by the Gateway.
Hi @Petanek333 - the Server string will need to match how the Gateway is configure, so can I suggest that you create a parameter called "Server" in your PBIX file which contains the IP string. When you publish this to the Power BI Web Service you can change the Parameter to the Server string. The new parameter value should be recognised by the Gateway.
Awesome, thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
26 | |
19 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
24 | |
13 | |
11 |