Forum Discussion
Simplifying ADLS queries
Hi ljag ,
Based on your description, you want to dynamically change your data source path to simplify the query process. You can use parameters to accomplish this process. Create a parameter in the power query and apply it to the fetch path. You can see how to do this in the following documentation
Solved: How to bulk change the source location for queries... - Microsoft Fabric Community
How to Parameterize Data Sources in Power BI | phData
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACADBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi ljag ,
Based on your description, you want to dynamically change your data source path to simplify the query process. You can use parameters to accomplish this process. Create a parameter in the power query and apply it to the fetch path. You can see how to do this in the following documentation
Solved: How to bulk change the source location for queries... - Microsoft Fabric Community
How to Parameterize Data Sources in Power BI | phData
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
this is great, thank you!
for future visitors, here is what to do:
- go to power query editor "Manager Parameters", then "New Parameter"
- name the parameter (I called mine adls_path), set type to Text
- create a list of values, one with the dev address and one with the prod address
- for every ADLS query, under Source and Navigation steps, replace the hardcoded address with adls_path
- to switch between dev and prod, go to the adls_path parameter and toggle the value to the one you want