I have a scenario which I would expect to be pretty typical and would like to know how others have solved this. I am creating a Power BI solution for a client whose source database is on a 3rd party hosting service. I have no way to connect to this database from my machine, use VPN etc. to get a connection to it. To be able to connect to the data and create data model and reports I have created a copy of the database which I have installed locally (SQL Server). When I publish to the service I of course want the data connection to be to the production database and not to my local copy, so I have created paramters for the sql server instance and the database name that I then can alter in the service once the desktop model is published there. This works fine but it requires me to change these parameters every time I publish to the service. Is there any way to have this done automatically or is there another way of doing it? Could using data flows be an option?