Change connection/server

Question

Hi,I created a small demo of charts etc. using an SQL Server connection and the desktop version of Power BI.Now I want to re-use the "pbix" file on another connection (another server, same DB name, same tables,views etc.).How can I achieve this? The "pbix" files seems to be not editable so that I cannot replace the connection string this way.&nbsp;Or is this not possible at all?&nbsp;ThanksKonrad

ashishrj · Answer

konradmd&nbsp;After clicking on edit queries in top ribbon. Find the steps as shown below. Hope this helps!&nbsp;

greg_deckler · Answer

Home tab, "Edit Queries", pick your query, click on the gear next to the Source step and edit the source.

malindajepsen · Answer

This works great if you have one data source.&nbsp; I have several queries from the same SQL Server that I need to change the connection to.&nbsp;I also need a way to do a "replace" for the database server/database.

v-sadadi · Answer

Hi,&nbsp;I even have several tables from the same SQL server. I want to update the Database name and Server name at a glance for all the tables.&nbsp;&nbsp;Please help me on this.&nbsp;ThanksSatya

bjoern · Answer

v-sadadi&nbsp;Well, I guess you either have toa) change all the advanced settings to the right DB name + servernameorb) use variables, as described in this blogpost.&nbsp;http://businessintelligist.com/2015/05/12/power-bi-tutorial-how-to-parameterize-connection-variables-in-power-query/&nbsp;... but in order to do that, you still have to touch all queries, i guess...

Forum Discussion

Change connection/server

9 Replies

Related content

Can't Connect Fabric Core MCP Server

Change server name in gateway connection

Problem connecting to report server

Power BI MCP Server not connecting to Power service

Connection string - change server adres