How to replace part of the M code in many queries at the same time

[molegris]

Hi,

I inherited the responsibility to maintain a large PowerBI file that has more than 80 queries.  It serves as a central dataset and presentation layer for many other reports.  The previous owner hardcoded the connection to the SQL server in each individual queries.  I want to use parameters.

Is it possible to do a search and replace to change the Source step in all the queries at once?

Something like this:

Search M code in all queries:     Source = Sql.Database("server1", "database1")

Replace M code in all queries:   Source = Sql.Database(ServerNameParam, DatabaseNameParam)

Thank you

[amitchandak]

@molegris , I doubt that. But let check with other super users

@ImkeF , can you help on this

[ImkeF · Accepted solution]

Hi @molegris ,

it requires a bit of setup, but then you can bulk-replace strings in your M-code at once: 
https://bengribaudo.com/blog/2020/07/16/5356/editing-report-spreadsheet-mashups-in-vscode

[molegris]

Thank you.  A bit complicated but I'll definitly try it and I'll let you know if it worked for me.