Setting Scheduled update on Dynamic source query

Hi, I've created a data source that retrieves files from a folder and performs actions based on the file name.
However, when I published it to the Power BI service, scheduled updates are disabled. Is there a way to resolve this? One solution might be to specify the path for each file needed and combine them all in the query.

Any thoughts?

Here is the code:

let
//Get the list of files from SharePoint
Source = SharePoint.Files("sharepointSite", [ApiVersion = 15]),
FolderUrl = "sharepointFolder",
//Filter the files to select only those starting with "A" or "B"
FilteredFiles = Table.SelectRows(Source, each Text.StartsWith([Name], "A") or Text.StartsWith([Name], "B")),

//Define a function to load data from each Excel file
LoadData = (file as text) =>
let
// Fetch the binary content of the Excel file
ExcelContent = Web.Contents(FolderUrl & file),

// Load the Excel workbook
ExcelWorkbook = Excel.Workbook(ExcelContent),

// Determine the sheet name based on the file name
DataSheetName =
if Text.StartsWith(file, "C") then "D"
else if Text.StartsWith(file, "E") then "F"
else null,

// Extract data from the specified sheet
DataSheet = if DataSheetName <> null then ExcelWorkbook{[Item=DataSheetName, Kind="Sheet"]}[Data] else null,

// Skip the first row if data exists
SkipFirstRow = if DataSheet <> null then Table.Skip(DataSheet, 1) else null,

// Add a column to identify the source file
AddSourceColumn = Table.AddColumn(SkipFirstRow, "FileSource", each file, type text)
in
// Return the resulting table
AddSourceColumn,

// Apply the LoadData function to each file and combine the results
CombinedData = Table.Combine(List.Transform(FilteredFiles[Name], each LoadData(_))),
in
#"CombinedData"