Mass-Editing of PQ-Script required due to change of Oracle-DB-Scheme

[thomasreick]

Good Morning,

The situation is as described below.

• Customer is running ~150 pBI reports, each one containing 1 to N datasources.
• These sources are imported as a complete view from Oracle into PQ.
• PQ is writing the server AND the scheme the view had been imported from.
• Now Customer-IT wants to replace the existing scheme with a different scheme name for all the views, thus affecting all reports and make them crash.

To avoid manual editing scheme-name of all PQ-Scripts I am looking for a smarter approach.

My Questions:

Is there a smart way to search and replace parts of PowerQuery-M-Code via a script?

Has anyone been confronted with a situation like this and how was it resolved.

Can you please share your expirience

Thanks for input.

Thomas

[Vijay_A_Verma]

For mass Find/Replace, you can use a third party free tool Power BI SideTools. This leverages Visual Source Code in turn. You can import your pbix file and then after changes export is back.

But it has a learning curve involved. You will have to see the video to learn. Make sure that you have a backup of your original pbix file before practicing on this.

[thomasreick]

Hi Vijay, thx for your input...

The tool requires to go file-by-file? This is exactly what we are trying to avoid.

Does the tool provide a "batch"-functionality e.g. to perform search&replace or all pbix-files in a directory?

Edited: I can see in the video presentation on that page that multiple files can be serched for DAX-Code but have not found yet a search functionality on M-Code

pls comment

Thx

Thomas