Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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