Dynamic Data Source Modification

[manuel_ak]

Hello Community,

For some reason, I keep getting this error in the image below: 

I have modified my MQuery lines several times to fix this issue but not resolution please any help will be appreciated. please see the except from the advanced editor below: 

let
    FolderPath = "..............\Production\Tip OD- 16F",
    Source = Folder.Files(FolderPath),
    #"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".csv")),
    #"Imported CSVs" = Table.AddColumn(#"Filtered rows", "Custom", each Csv.Document(File.Contents([Folder Path] & [Name]), [Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None])),
    #"Removed First 4 Rows" = Table.TransformColumns(#"Imported CSVs", {"Custom", each Table.Skip(_, 4)}),
    #"Expanded Content" = Table.ExpandTableColumn(#"Removed First 4 Rows", "Custom", {"Column1", "Name", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10"}),
    #"Filtered Name" = Table.SelectRows(#"Expanded Content", each Text.StartsWith([Name], "20")),
#"Combined Tables" = Table.Combine(#"Filtered Name")
in
#"Combined Tables

[Anonymous]

Hi @manuel_ak ,

Please consider avoiding the use of dynamic variables as the file path for Folder.Files, as it may be treated as a dynamic data source and could cause issues during refresh.

let
    Source = Folder.Files("..............\Production\Tip OD- 16F"),
    #"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".csv")),
    #"Imported CSVs" = Table.AddColumn(#"Filtered rows", "Custom", each Csv.Document(File.Contents([Folder Path] & [Name]), [Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None])),
    #"Removed First 4 Rows" = Table.TransformColumns(#"Imported CSVs", {"Custom", each Table.Skip(_, 4)}),
    #"Expanded Content" = Table.ExpandTableColumn(#"Removed First 4 Rows", "Custom", {"Column1", "Name", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10"}),
    #"Filtered Name" = Table.SelectRows(#"Expanded Content", each Text.StartsWith([Name], "20")),
#"Combined Tables" = Table.Combine(#"Filtered Name")
in
#"Combined Tables

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-source...

Best Regards,

Bof

[Anonymous]

Pretty sure that means that you can't use a parameter in your data source in a Dataflow. 

--Nate

[manuel_ak]

Please are you able to show an example of a modification that might work?