Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change data source in Power BI Dataflow

I have created a Dataflow using Azure SQL Server as source. Now, the name of the server got changed rather server got changed. I am unable to get any option to change the name of the data source of t...
Dataflow
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    You may click 'Edit Entities' and go to Power Query.

     

    Then you can go to 'Home' ribbon, click 'Advanced editor' and modify the server name in the qurey.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    I'd like to suggest you use 'Manage Parameters' to parameterise a data source. You may use the corresponding parameter replacing the server name. If you want to change the server name, you just modify the parameter as what you want.

     

    For further information, you may refer to the article .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

You may click 'Edit Entities' and go to Power Query.

 

Then you can go to 'Home' ribbon, click 'Advanced editor' and modify the server name in the qurey.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-alq-msft , Thanks a lot for this. It worked. But In this case, I have to change the server name for all the entities one by one. Is there any way to do this at a time? Thanks again. 

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    I'd like to suggest you use 'Manage Parameters' to parameterise a data source. You may use the corresponding parameter replacing the server name. If you want to change the server name, you just modify the parameter as what you want.

     

    For further information, you may refer to the article .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.