Change SQL query once

[IanCockcroft]

Hi guys, is it possible to open the txt file for a pbix?

the same as the ADVANCED option in power query

I have 45 SQL connectiopns and want to add a WITH NOLOCK to each query without having to open each connection.

any idea?

[lbendlin · Accepted solution]

PBIX files are ZIP archives that contain various other files and folders, some compressed, some in clear text. While you could write a script to do these manipulations it will be (much) faster to just do the change manually 45 times.

Also read about PBIP and TMDL.