I am using the Power Query to get data directly from a MS SQL Server we use.
Instead of having to add the code into the window I want it to reference a separate file instead
Highlighted below is the default syntax used
Capture1.PNG
I want to replace the highlighted portion with a file path instead, or something that would achieve the same thing.
Reason for needing this, the query I use needs to be changed at weekly intervals, and once a query is placed the formatting is a mess and making changes is quite hard
Bookmarks