Forum Discussion

Petanek333's avatar
Petanek333
Icon for Helper III rankHelper III
3 years ago
Solved

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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 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's avatar
Anonymous
Not applicable
3 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.

  • Petanek333's avatar
    Petanek333
    Icon for Helper III rankHelper III
    3 years ago

    Anonymous  thank you very much, it worked! 

  • iBusinessBI's avatar
    iBusinessBI
    Icon for Kudo Collector rankKudo Collector
    2 years ago

    Awesome, thanks!