Forum Discussion
Change connection/server
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 nam...
Hi,
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.
Please help me on this.
Thanks
Satya
Well, I guess you either have to
a) change all the advanced settings to the right DB name + servername
or
b) use variables, as described in this blogpost.
... but in order to do that, you still have to touch all queries, i guess...