Forum Discussion

manuel_ak's avatar
manuel_ak
New Member
1 year ago

Dynamic Data Source Modification

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

 

 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

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

    --Nate

    • manuel_ak's avatar
      manuel_ak
      New Member
      1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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-sources

     

    Best Regards,

    Bof