Forum Discussion
IanCockcroft
Post Patron
Post PatronChange SQL query once
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?
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.
1 Reply
- lbendlin
Super User
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.