Replace Data Source of Each Query with Generic Data Source

[Alex_G7]

Hi 

I am selecting from view in my projects 

I want change Data source for all queries to generic Data Source when I will move from dev to prod

1. I created Blank Query 

DS_AG

usinng Advice editor I specified Source as 

let
Source = Sql.Database("DESKTOP-DJZ12\AGCMS", "PowerBIDX")
in
Source

In my Existing  Query01  Source  

let
Source = Sql.Database("DESKTOP-DJZ12\AGCMS", "PowerBIDX", [Query="SELECT [DATAAREAID] as LegalEntity,#(lf) [NAME] as LegalEntityName#(lf)FROM [V_CompaniesLegalEntities]"])
in
Source

I   want to replace "DESKTOP-DJZ12\AGCMS", "PowerBIDX"  with DS_AG

something  like 

let
Source = Sql.Database("DS_AG", [Query="SELECT [DATAAREAID] as LegalEntity,#(lf) [NAME] as LegalEntityName#(lf)FROM [V_CompaniesLegalEntities]"])
in
Source

please help with syntax  or  show example

[v-frfei-msft · Accepted solution]

Hi @Alex_G7 ,

Based on my test, we can add parameters firstly in power query. I take SQL Server as an example here as the same as yours.

Then we can get data and use the Parameter that we created. For more details, please check the online document.

[Alex_G7]

Thank ypu 

 its is very simply and wokring solution