M-Language functions (use dynamic file location)

[RafaelKnuth]

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.Contents("C:\Users\Participants_January2018.txt"),[Delimiter="	", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Participant", type text}, {"ID", Int64.Type}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Participant", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Participant.1", "Participant.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Participant.1", type text}, {"Participant.2", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Participant.1", "First Name"}})
in
    #"Renamed Columns"

[v-yulgu-msft]

Hi @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