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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      This doesn't work for tables in DirectQuery mode. Is there another way to do this for DQ?