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
ashishrj's avatar
ashishrj
Power Participant
10 years ago

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

 

SQL.png

konradmd's avatar
konradmd
Regular Visitor
10 years ago

Thank you both for your help. This worked as a first step for me.

 

But can I change the datasource/credentials in a pbix-file without any user interaction, e.g., via command line or a startup parameter of the desktop version of PowerBI?

  • 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.

    • v-sadadi's avatar
      v-sadadi
      Microsoft Employee
      10 years ago

      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

    • 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),