Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |