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

Yes unfortunately I still have the same error here  

Please correct me if I am wrong in this picture(SQLServer{"server":"IP Adress"......) IP address is same with the IP adress that I create report and where GW is installed.

But for add to gateway page I insert my local IP address

lbendlin's avatar
lbendlin
Super User
2 years ago

Both in the desktop and on the gateway connection management you should ideally specify the FQDN of the SQL server, not the IP address.

 

Did you add the connection to the "Power BI GW"  gateway?

 

All your blackouts are not helping with the troubleshooting.