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

Ows's avatar
Ows
Frequent Visitor
2 years ago

Okay so one last question can I still use my desktop to PUBLISH reports or should I also PUBLISH reports from VM where gateway is?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    You continue to use Power BI Desktop on your PC for that.   You can install Power BI Desktop on a gateway VM but that is not required in regular operations, only for troubleshooting  (and it eats 2.5 GB of disk space that you will rather want to give to the gateway log files).