Power Query - Excel - Passing a variable to the middle of URL datasource

[datasetleo]

Hi, All!

I drilled down an item in a query, which I'd like to add it to datasource's URL to make it dynamic.

I can't find the right syntax. can anyone please help how to pass the variable?

Screenshots below - drill down query is called [aaa_report] and I wanted to add it to replace the month in the URL  (which in this case is june_2019)

In addition, is there any way to ensure this drill-down query gets called first once refreshed all?

Thank you!

[Stachu · Accepted solution]

assuming the query that returns june_2019 is named prmQuery, the path string should change from

"d:\my Documents\project\june_2019\df\total.csv"

to

"d:\my Documents\project\" & prmQuery & "\df\total.csv"

if other queries are dependant on it PowerQuery will manage the order automatically

[datasetleo]

@Stachu , BIG THANK YOU! 

[datasetleo]

Thanks @Stachu 

It looks like I am missing something; when I added query in "& query &" - I got firewall exemption. I do have access to the file obviously - any way to circumvent this error? Thanks again!

[Stachu]

the reason are security settings:

https://docs.microsoft.com/en-us/power-bi/desktop-privacy-levels

you need to change them to be consistent for the data sources you mix together (e.g. all organizational, depending on your requirements), it's all explained in the article