Forum Discussion
RafaelKnuth
Advocate I
Advocate IM-Language functions (use dynamic file location)
How do I tweak the function below in order to dynamically fetch a file's location? (currently, source is hard coded) - thanks! (CleanUpParticipants) =>
let
Source = Csv.Document(File.Conten...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi RafaelKnuth,
You can try to make use of Query Parameters and Power BI Templates to dynamically switch data sources. Here are some similar examples for your reference:
How can I create dynamic file references in Power Query?
Dynamically change data source of published report
POWER BI DESKTOP QUERY PARAMETERS, PART 1
Best regards,
Yuliana Gu