ODBC connection reading from a external file in Desktop

[Rachamallu01]

We would like to read the ODBC connection string paramaters from a external file.

As shown below we would like to modfiy the connection string for Desktop. We are using desktop for in house power bi server

let
Source = Odbc.DataSource("dsn=AaDatabase", [HierarchicalNavigation=true]),
db_a1_Database = Source{[Name="db_1",Kind="Database"]}[Data],
aa_datamart_Schema = db_Database{[Name="datamart_dev",Kind="Schema"]}[Data],
app_vw_View = aa_datamart_Schema{[Name="app_vw",Kind="View"]}[Data]
in
app_vw_View

let
Source = Odbc.DataSource("dsn=AaDatabase2", [HierarchicalNavigation=true]),
db_a1_Database = Source{[Name="db_2",Kind="Database"]}[Data],
aa_datamart_Schema = db_Database{[Name="datamart_UAT",Kind="Schema"]}[Data],
app_vw_View = aa_datamart_Schema{[Name="app_vw",Kind="View"]}[Data]
in
app_vw_View

would like to know if this possible, if so any help is appreciated

[amitchandak]

@Rachamallu01 , You can try that using parameterize connection, But I doubt you can use external file

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712