Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.