Connecting Power BI Desktop to a remote SQL Server with no VPN connection

KevinColes Not sure you have many choices? Simply you need access to the SQL server, either thru RDP to the clients networks and do the development their assuming you have access to SQL server from the RDP machine or make a replicate of SQL server at your end, develop report connecting to local server, use parameters for connection to the SQL server, after report is published, change parameter value to connect to client's SQL server and you are good to go.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.