Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Morning,
The situation is as described below.
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
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.
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