Forum Discussion

konradmd's avatar
konradmd
Regular Visitor
10 years ago

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...
Need Help
malindajepsen's avatar
malindajepsen
Advocate I
10 years ago

This works great if you have one data source.  I have several queries from the same SQL Server that I need to change the connection to.

 

I also need a way to do a "replace" for the database server/database.

medwards807's avatar
medwards807
Helper I
9 years ago

You most likely know this by now:

 

Create a Blank Query 

 

//CRMServiceURl//

   let
       Source = "https://<tenant>.api.crm.dynamics.com/api/data/v8.1"
   in
       Source

 

Note: Uncheck Enable on Load (So that it does not appear as a table (You can aslo use a parameter


Update All Other Queries

let
Source = OData.Feed(CRMServiceURL),