How can i create parameters to changes source tables from dev to prod for Azure SQL DB

[ChavvaPadma]

Hello Everyone,

How can i change table connections dynamically from test to prod with Azure sql db

Regards

Chavva

[Abhilash_P · Accepted solution]

Hi @ChavvaPadma 

1. Create parameter from Manage Parameters in Power query

2. Select the parameter as database and provide the paramers