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 

 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

 

Best Regards

Allan