Switching URL is easy, that’s actually why I split off RelativePath. The URL root is static, mostly. BAQ only requires updating one bit, unless there are parameters, and those aren’t bad. Whatever you get working, copy that off to a snippet somewhere with the important bits arranged somewhat obviously, and it’s just a matter of cut-paste from here on.
And don’t discount @NateS note! Power query uses M just like Power BI. You can literally paste the same M between Excel and PBI. Excel is super quick and powerful for drilling into the outputs of your M.
/edit, random thought…
YAGNI doesn’t get the time in the spotlight it deserves. It’s good to know the options, a virtue to hold on implementation until you are gonna need it.