Forum Discussion

Ows's avatar
Ows
Frequent Visitor
2 years ago
Solved

Remote Desktop SQL Server Connection

Hello I used to have on premises on my personal laptop but now I install it to our Remote Desktop where our SQL Database is.Because I want reports to be live all the time.Thats why I upgrade my acco...
dataflow
Need Help
  • AUDISU's avatar
    AUDISU
    2 years ago

    Hi Ows ,

    You can not connect data getway untill you have the same server name in power bi report and Remote Desktop server.

    Solution is create a parameter in your power bi report and store sql server (Personal Computer) in that parameter. Once you publish the reprt in the server change parameter values to Remote Desktop server.
    Then it shows your getway to connect.

    Thanks

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
but now I install it to our Remote Desktop where our SQL Database is

Don't do that.  Enterprise Gateway should be installed on its own VM.  

 

After publishing to the workspace, go to the Semantic Model settings page and rewire the gateway connection.

Ows's avatar
Ows
Frequent Visitor
2 years ago

So you mean that I need to uninstall gateway from terminal server and install it to own server.
Can you inform me why we cant get the data from terminal server?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Gateway is extremely resource hogging and will starve all other apps/services of Compute and Memory.  As it should - that's what it is designed for.