Forum Discussion
Petanek333
3 years agoHelper III
Gateway and Desktop with different server names
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 a...
- Anonymous3 years ago
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.
Anonymous
3 years agoNot applicable
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.
iBusinessBI
2 years agoKudo Collector
Awesome, thanks!