Simplifying ADLS queries

Hi all,

I maintain a pretty large report that currently has a bunch of queries to our Azure Data Lake -- 14 of them as of now.

We have both dev and prod spaces for the Azure space and keep dev and prod versions of the PBI report as well. We test new data and visuals in the dev report on dev data, then switch to prod data and publish as a prod report.

Dev and prod spaces are denoted by a "d" or "p" in the ADLS web address in the PQE source and navigation steps (for example adls-d.dfs.core.windows.net/folder or adls-p.dfs.core.windows.net/folder). Currenly I have to just go in to each query and manually change the "d" or "p".

Basically my question is if there is some kind of helper query or shortcut I can use to change it only once and have it flow through to the rest of the queries so I don't have to go into these steps for all 14 of them and change a letter.

Thanks!